T-SQL usefull stuff

Move table to different schema

ALTER SCHEMA targetSchema TRANSFER sourceSchema.tableName

Rename object

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




Close all connections to database

USE master;
GO

ALTER DATABASE dbName
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

ALTER DATABASE dbName
SET MULTI_USER;
GO