SQL, how to update a table structure
New Course Coming Soon:
Get Really Good at Git
How to update a SQL database table structure
We can alter an existing table structure using the ALTER TABLE
command, followed by the alteration you want to make:
ALTER TABLE people ADD COLUMN born_year INT;
This will add a new column with empty values:
age | name | born_year
-----+--------+-----------
37 | Flavio |
8 | Roger |
To drop a column:
ALTER TABLE people DROP COLUMN born_year;
This will result in:
age | name
-----+--------
37 | Flavio
8 | Roger
→ Read my SQL Tutorial on
The Valley of Code
Here is how can I help you:
- COURSES where I teach everything I know
- CODING BOOTCAMP cohort course - next edition in 2025
- BOOKS 16 coding ebooks you can download for free on JS Python C PHP and lots more
- Follow me on X