Script which generates all the tables in database along with its schema name.
SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'
AS
SchemaTable
FROM sys.tables
Posts
Wednesday, October 3, 2012
Subscribe to:
Post Comments (Atom)
Readers
My Blog List
Categories
- Case When Statement (2)
- CMD (1)
- Database Email (1)
- DatePart (1)
- Definitions (37)
- ERROR (1)
- Functions (11)
- INDEXING (2)
- LINQ (1)
- Search (1)
- Smo (3)
- Split Function (2)
- SSRS (2)
- System Stored Procedure (4)
- Transaction (1)
- Wildcard (1)
- XML (3)
No comments:
Post a Comment