# ALTER TABLE Statement

### SQL ALTER TABLE Statement

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

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

### ALTER TABLE - ADD Column

To add a column in a table, use the following syntax:

```sql
ALTER TABLE table_name
ADD column_name datatype;
```

The following SQL adds an "Email" column to the "Customers" table:

```sql
ALTER TABLE Customers
ADD Email varchar(255);
```

### ALTER TABLE - DROP COLUMN

To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column):

```sql
ALTER TABLE table_name
DROP COLUMN column_name;
```

The following SQL deletes the "Email" column from the "Customers" table:

```sql
ALTER TABLE Customers
DROP COLUMN Email;
```

**ALTER TABLE - ALTER/MODIFY COLUMN**

To change the data type of a column in a table, use the following syntax:

**Syntax:**

```sql
ALTER TABLE table_name
ALTER COLUMN column_name datatype;
```

SQL ALTER TABLE Example

Look at the "Persons" table:

![](https://826093633-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LS8lPNzCGPR5-DLbGXv%2F-LScTirqg4W2gpV3ZG4E%2F-LScUwRk315rALBZ2Cj0%2Fimage.png?alt=media\&token=4d4789b8-bd0e-4136-970c-51268b008d91)

Now we want to add a column named "DateOfBirth" in the "Persons" table.

We use the following SQL statement:

```sql
ALTER TABLE Persons
ADD DateOfBirth date;
```

Notice that the new column, "DateOfBirth", is of type date and is going to hold a date. The data type specifies what type of data the column can hold. For a complete reference of all the data types available in MS Access, MySQL, and SQL Server, go to our complete [Data Types reference](https://www.w3schools.com/sql/sql_datatypes.asp).\ <br>

![](https://826093633-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LS8lPNzCGPR5-DLbGXv%2F-LScTirqg4W2gpV3ZG4E%2F-LScVGaAfUCbgFmzkz5z%2Fimage.png?alt=media\&token=107ef40b-040f-440a-b226-4280f3833abb)

\
**Change Data Type Example**

Now we want to change the data type of the column named "DateOfBirth" in the "Persons" table.

We use the following SQL statement:

```sql
ALTER TABLE Persons
ALTER COLUMN DateOfBirth year;
```

![](https://826093633-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LS8lPNzCGPR5-DLbGXv%2F-LScTirqg4W2gpV3ZG4E%2F-LScV_eyCcFh_QPVjSwF%2Fimage.png?alt=media\&token=d9fc94c6-974f-48aa-9c01-9d22c4327399)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://gyansetu-sql.gitbook.io/sql-programming/sql-database/sql-alter-table-statement.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.