Various T-SQL scripts, code blocks or routines for daily use.
Metadata
- Check for name of an object in all databases
- Compressed Tables List
- Generate UNION ALL views for all tables from all databases with the same schema
- List all tables and columns with user-friendly datatype names
- List Foreign Key Relations
- List of all Columns with Default Constraint participating in Foreign Key
- List of database tables with column names divided by comma
- List of Tables with Columns, Data Types and Primary Key and Identity information
- Number of Rows and Data and Indexes Space Used Per Table
- Primary Keys List
Tables
- Backup single table with timestamp
- Drop all tables in database
- Drop all tables in schema (WHILE mode)
- List all Tables with IDENTITY column exists information
- List of Tables with Number of Rows Including Data and Indexes Size
- Reset IDENTITY_INSERT setting for session in case it is ON for unknown table
- Reset IDENTITY_INSERT to OFF for all tables
- Truncate all tables in database