SQL Server

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
Ebook Download
View all
Learn
View all
Membership not found