T-SQL Tricks

Few useful SQL tricks:

Move table to different schema

ALTER SCHEMA targetSchema TRANSFER sourceSchema.tableName

Rename object

sp_rename 'schemaName.tableName.columnName', 'newColumnName'