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)
SQL Server Transact Basic to Expert - Alter Table Query
SQL Server Transact Basic to Expert - Alter Table Query
Join the conversation! Your thoughts help the community grow.