2.5. CHANGE DATATYPE OF COLUMN IN TABLE
QUERY :- ALTER TABLE employee ALTER COLUMN lastname varchar(50);
Last modified: Monday, 2 December 2019, 12:16 PM
MS SQL Server Basic
Its change datatype of lastname column nvarchar to varchar.
QUERY :- ALTER TABLE employee ALTER COLUMN lastname varchar(50);