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
SQL Server Transact Basic to Expert - Alter Column Query
SQL Server Transact Basic to Expert - Alter Column Query

Join the conversation! Your thoughts help the community grow.