SQL-Server-T-SQL

Summary of the useful of SQL Server T-SQL scripts

Database

1. Restore database with new name

Table

1. Truncate all tables
2. Delete all tables

Column

1. Search all columns by string
2. Search column name by string
3. Update column From Select

Foreign Key

1. List All Foreign Key

Stored Procedure

1. Search all stored procedures

Database Diagram

1. Copy Database Diagram