# 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 %}