HowFastAll

Add Column - Adds a column to a table

ALTER TABLE test.dbo.Employee ADD new_col char(25) DEFAULT '4' NOT NULL

Add Primary Key - Adds a primary key to a table

ALTER TABLE test.dbo.Employee ADD PRIMARY KEY (ssn)

Add Foreign Key - Adds a foreign key to a table

ALTER TABLE test.dbo.Employee ADD FOREIGN KEY (dno) REFERENCES test.dbo.Department(dnumber)

Add Constraint - Adds a check constraint to a table

ALTER TABLE test.dbo.Employee ALTER COLUMN ssn char(25)

Change Column Type - Changes the data type of a column

ALTER TABLE test.dbo.Employee DROP COLUMN ssn

Drop Column - Drops a column from a table

ALTER TABLE test.dbo.Employee DROP CONSTRAINT test_const

Drop Constraint - Drops a check constraint from a table

ALTER TABLE test.dbo.Employee DROP CONSTRAINT PK__Employee__15502E78

Drop Primary Key - Drops a primary key from a table

ALTER TABLE test.dbo.Employee DROP CONSTRAINT FK__Employee__dno__182C9B23;

Drop Foreign Key - Drops a foreign key from a table

ALTER TABLE test.dbo.Employee DROP CONSTRAINT FK__Employee__dno__182C9B23;

Rename Table - Renames a table

exec sp_rename @objname = 'test.dbo.Employee', @newname = 'Employee_new'

Rename Column - Renames a column

exec sp_rename @objname = 'test.dbo.Employee.ssn', @newname = 'ssn_new', @objtype = 'COLUMN'