SQL Server Transact Basic to Expert - Alter Column Query

SQL Server Transact Basic to Expert - Alter Column Query

This blog shows how to alter a column in a table using the alter column query.

Syntax:

Alter table tablename
Alter column Columnname
(Datatype Null/Not Null)

Example:

Alter table emptable
Alter Column empname varachar(200) Not Null