SQL Server Transact Basic to Expert - Alter existing column Definition


This blog shows on how to alter the existing table definition.

Syntax:
ALTER TABLE table_name
ALTER COLUMN column_name Datatype [NULL | NOT NULL]

Example:

Alter table emptable
Alter Column empsal Varchar(15) Null