Alter Column Type
How to change a table column type in SQL ServerRename A Column
How to rename a table column in SQL ServerAlter Column Default
How to change a column's default value in SQL ServerAlter Column Nullable
How to change the nullable flag on a SQL Server table columnCREATE INDEX examples
How to create an index on one (or many) columns in SQL Server.Alter Table Add Foreign Key
Adding a foreign key (otherwise known as a relation or association) to a SQL Server table means adding a 'constraint'. These basic examples assume that the column type is correct, and any existing values match existing relation IDs in the target table.Alter Table Drop Foreign Key / Constraint
Removing a foreign key (otherwise known as a relation or association) from a SQL Server table. Note that after removing a relation, you might also want to remove any left over indexes.Alter Table
A SQL Server example for changing, adding, and removing columns for an existing table