Useful T-SQL Scripts

Use this wiki to look for (or add) T-SQL scripts you find useful.

Rename a table

sp_rename 'OriginalTableName', 'NewTableName'

Rename a column

sp_rename 'TableName.OriginalColumnName', 'NewColumnName'