> For the complete documentation index, see [llms.txt](https://sql.stockeasymoney.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sql.stockeasymoney.com/table-structure/untitled-1.md).

# Alter Table

Add column

{% code title="add column" %}

```sql
ALTER TABLE `u367669158_tutor`.`students`
ADD email VARCHAR(30) not NULL;
```

{% endcode %}

Modify column

{% code title="modify column" %}

```sql
ALTER TABLE `u367669158_tutor`.`students`
MODIFY email INT(20) NULL;
```

{% endcode %}

Drop column

{% code title="drop column" %}

```sql
ALTER TABLE `u367669158_tutor`.`students`
DROP COLUMN email;
```

{% endcode %}