---
title: "Drop Column in SQL Server"  
description: "In this blog, I have described how to drop the column from existing table. For demonstration, I have used a table that given below.  CREATE TABLE [dbo"  
author: "AVADHESH PATEL"  
published: 2012-12-30  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/418/drop-column-in-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Drop Column in SQL Server

In this [blog](https://www.mindstick.com/articles/12705/myths-and-misconception-about-blog), I have described how to [drop](https://www.mindstick.com/forum/159028/delete-and-drop-statements-in-sql-server) the column from [existing table](https://www.mindstick.com/forum/157761/how-to-add-a-column-with-a-default-value-to-an-existing-table-in-sql-server). 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> DROP COLUMN <[Column Name](https://www.mindstick.com/forum/369/how-can-i-add-a-column-name-to-my-grid)>

\

Example:

```
ALTER TABLE [dbo].[EmpInfo]DROP COLUMN [Date]
```

---

Original Source: https://www.mindstick.com/blog/418/drop-column-in-sql-server

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