SQL Server Transact Basic to Expert - Alter Table Query

SQL Server Transact Basic to Expert - Alter Table Query

This blog shows how to alter an existing table using the alter command

Syntax:

Alter table Tablename
Add (Column name datatype null/not null)

Example:

Alter table emptable
Add (empSalary int Not Null)