Changing Data Type of Column in SQL Server

Hello to everyone,

In this article, I will give information about how to change the data type of a column in SQL Server.

In SQL Server you may need to change the data type of a column in some cases.

You can do this easily using the code below.

--Creating a sample database

CREATE TABLE ExampleDBTable(
ID INT PRIMARY KEY IDENTITY(1,1),
NAME NVARCHAR(100)
)

--Changing Data Type of Column in SQL Server

ALTER TABLE ExampleDBTable 
ALTER COLUMN NAME NVARCHAR(200)

When you run the code, you will get a result like the one below.

As you can see, the column data type of the table has been changed.

Good luck to everyone in business and life.