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),
--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.