How do you change the datatype of a column in MS SQL?

Question

I am trying to change a column from a varchar(50) to a nvarchar(200). What is the SQL command to alter this table?

Answer 1

Alter table TableName Alter Column ColumnName nvarchar(200)

Answer 2

Hi,

Use the Alter table statement.

Alter table TableName Alter Column ColumnName varchar(100)

Answer 3

Don't forget nullability.

ALTER TABLE <schemaName>.<tableName>
ALTER COLUMN <columnName> nvarchar(200) [NULL|NOT NULL]