Simon's Bits and Bobs
Tuesday, 21 June 2016
SQL Server- List all tables with schema name for a given DB
SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'
AS SchemaTable
FROM sys.tables
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment