Create Database
Generates a script to create a new SQL Server database with specified options.
Database Management
Creation
DDL
Create Table
Provides a script to define a new table with various column types, constraints, and indexes.
Schema Design
Table Creation
DDL
Insert Sample Data
A flexible template for inserting sample data into existing tables, with options for batch size.
Data Management
DML
Testing
Generate CREATE TABLE from Existing Table
Reverse-engineers an existing table structure to generate its CREATE TABLE script.
Schema Analysis
DDL Generation
Documentation
Check Database Size
Script to determine the current size of a database and its log files.
Monitoring
Performance
Administration
Backup Database
Generates a script for performing a full, differential, or transaction log backup.
Backup & Restore
Data Protection
Administration
Drop Database
A script to safely drop a database, including handling existing connections.
Database Management
Deletion
DDL
Rebuild Index
Script to rebuild fragmented indexes to improve query performance.
Performance Tuning
Indexing
Maintenance