alter table vehicletype add year varchar(100) ALTER TABLE vehicletype ALTER COLUMN Code nvarchar(50) NULL; ALTER TABLE vehicletype ALTER COLUMN Name nvarchar(500) NULL;