Sunday, 2 December 2012

SQL SERVER – List Schema Name and Table Name for Database


SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'
AS SchemaTable
FROM sys.tables
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)