SQL: Updating a table structure

We can alter an existing table structure visually with TablePlus, but we can do that using SQL too, using the ALTER TABLE command, followed by the alteration you want to make:

ALTER TABLE people ADD COLUMN born_year INTEGER;

This will add a new column with empty values:

We can drop a column in this way:

ALTER TABLE people DROP COLUMN born_year;

Lessons in this unit:

0: Introduction
1: Using TablePlus
2: Create a Postgres database
3: Create a new table
4: Add data to a table
5: Query data with SELECT
6: Delete data from the database
7: Update data with UPDATE
8: Null constraints
9: Unique and primary keys
10: ▶︎ Updating a table structure
11: Joins
Want to learn more? Check out our courses