---
title: "Changed Data Type of column in SQL Server"  
description: "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 T"  
author: "AVADHESH PATEL"  
published: 2012-12-31  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/423/changed-data-type-of-column-in-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Changed Data Type of column in SQL Server

In this [blog](https://www.mindstick.com/articles/12705/myths-and-misconception-about-blog) I have described how to changed [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) type of [existing column](https://www.mindstick.com/forum/159775/how-do-you-modify-an-existing-column-s-data-type-in-a-table-using-sql) 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](https://www.mindstick.com/forum/811/alter-table-with-a-default-sql-server-vs-oracle) <Table Name> ALTER COLUMN <[Column Name](https://www.mindstick.com/forum/369/how-can-i-add-a-column-name-to-my-grid)> <New Data Type> <[Size](https://www.mindstick.com/forum/159799/how-can-you-manage-the-size-of-mdf-and-ldf-files) Depend on Data Type>

\

##### Example:

#####

```
ALTER TABLE [dbo].[EmpInfo]ALTER COLUMN [DATE] DATETIME
```

---

Original Source: https://www.mindstick.com/blog/423/changed-data-type-of-column-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.