SQL Alter Table

In an earlier lesson, we created a table with the CREATE TABLE command. In this lesson, we will modify the table using the ALTER TABLE command.

Add a Column

Here's the syntax for adding a column.

And here's a SQL statement that adds a column called age to the Individual table.

To change the data type, use ALTER COLUMN instead of ADD.

Here, we change the datatype of the age column to numeric.

"Dropping" a column means removing or deleting that column.

Use DROP COLUMN followed by the name of the column you want to drop.

Here, we drop the age column that we added above.