Change the schema on an existing table.
ALTER SCHEMA projectManagement
TRANSFER dbo.RequestPriority
Alter a column in an existing table.
ALTER TABLE [projectManagement].[Task]
ALTER COLUMN Name varchar(250) not null
Add a new identity column to an existing table.
-- See http://stackoverflow.com/a/3698824/11912
ALTER TABLE JobSupplies add Id INT IDENTITY
ALTER TABLE JobSupplies add constraint PK_JobSupplies primary KEY(Id)
Migrated to https://cmds.jamesrskemp.com/tsql.html