Home > DeveloperSection > Blogs > Changed Data Type of column in SQL Server

Changed Data Type of column in SQL Server


Database Database 
Ratings:
0 Comment(s)
 1727  View(s)
Rate this:

Changed Data Type of column in SQL Server

In this blog I have described how to changed data type of existing column of table. For demonstration I have used a table that given below.

CREATE TABLE [dbo].[EmpInfo]

(

[ID] INT IDENTITY PRIMARY KEY,

[Name] VARCHAR(50),

[Date] VARCHAR(50)

)

Syntax:

ALTER TABLE <Table Name> ALTER COLUMN <Column Name> <New Data Type> <Size Depend on Data Type>

Example:

ALTER TABLE [dbo].[EmpInfo]

ALTER COLUMN [DATE] DATETIME

Don't want to miss updates? Please click the below button!

Follow MindStick