Tuesday, 23 June 2015

List Schema Name and Table Name for Database

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)