---
title: "How to add and remove columns from an existing table in the database?"  
description: "How to add and remove columns from an existing table in the database?"  
author: "Ravi Vishwakarma"  
published: 2021-09-21  
updated: 2021-09-21  
canonical: https://www.mindstick.com/forum/156738/how-to-add-and-remove-columns-from-an-existing-table-in-the-database  
category: "database"  
tags: ["database", "mysql", "sql server", "sql"]  
reading_time: 1 minute  

---

# How to add and remove columns from an existing table in the database?

How to [add and remove](https://www.mindstick.com/forum/160516/how-to-add-and-remove-a-column-in-datatable-in-dot-net-using-c-sharp) columns from an existing [table in the database](https://www.mindstick.com/forum/157515/what-are-ddl-triggers-create-a-trigger-to-prevent-a-user-to-delete-a-table-in-the-database)?

## Replies

### Reply by Ashutosh Kumar Verma

**SQL [Add](https://www.mindstick.com/forum/12983/add-address-in-textbox-when-page-is-load-and-if-i-search-address-in-textbox-show-in-map-by-javascript) column in [existing Table](https://www.mindstick.com/forum/159766/what-is-the-syntax-for-renaming-a-column-in-an-existing-table-using-sql) :**

To Add a column in existing table in SQL [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) we can use SQL ALTER command. The following SQL statement is used to Add a column in existing table.

Lets take a database table 'Student',

![How to add and remove columns from an existing table in the database?](https://www.mindstick.com/mindstickforums/a79e3627-e9c7-4284-9166-f70380010985/images/f1667837-bb17-4ea8-8a76-9dfca6884cb1.png)

Now, the following SQL Statement is used to add a Column 'stuMarks' in above table,

```
ALTER TABLE Student
ADD stuMarks int;
```

![How to add and remove columns from an existing table in the database?](https://www.mindstick.com/mindstickforums/a79e3627-e9c7-4284-9166-f70380010985/images/3fc0ccee-9848-4215-ae16-8062cccbba87.png)

**[Remove](https://yourviews.mindstick.com/story/4554/8-harmful-weeds-to-remove-from-garden) Column from existing table :**

To remove a column from existing database table, used SQL ALTER command. The following SQL statement is used to remove or delete a column 'stuMarks' from existing above table,

```
alter table Student
drop column stuMarks;
```

![How to add and remove columns from an existing table in the database?](https://www.mindstick.com/mindstickforums/a79e3627-e9c7-4284-9166-f70380010985/images/7598208b-f754-4bf4-a135-eb1278ffa0ba.png)

In the above example 'stuMarks' column is deleted successfully.


---

Original Source: https://www.mindstick.com/forum/156738/how-to-add-and-remove-columns-from-an-existing-table-in-the-database

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