---
title: "What is the use of Alter Table command in database?"  
description: "What is the use of Alter Table command in database?"  
author: "Anonymous User"  
published: 2010-10-16  
updated: 2020-09-21  
canonical: https://www.mindstick.com/interview/36/what-is-the-use-of-alter-table-command-in-database  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is the use of Alter Table command in database?

The ALTER table command is used to add, delete, or modify columns in an existing table.\
\
To add a column in a table, use the following syntax:\
\
ALTER TABLE table_name\
ADD column_name datatype\

## Answers

### Answer by Anonymous User

The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table.\

**Use of ALTER command in database**\

Alter command is used for change the column name, add column, add constraint, and change the datatype.

Syntax: Add Column name

ALTER TABLE table_nameADD column_name datatype

Syntax: Delete a Column

ALTER TABLE table_nameDROP COLUMN column_name

Syntax: Change Column Name

ALTER TABLE table_nameALTER COLUMN column_name datatype

### Answer by Pushpendra Singh

The ALTER table command is used to add, delete, or modify columns in an existing table.\
\
To add a column in a table, use the following syntax:\
\
ALTER TABLE table_name\
ADD column_name datatype\


---

Original Source: https://www.mindstick.com/interview/36/what-is-the-use-of-alter-table-command-in-database

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