Skip to content

SQL, how to update a table structure

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

→ Here's my latest YouTube video

→ I wrote 17 books to help you become a better developer, download them all at $0 cost by joining my newsletter

JOIN MY CODING BOOTCAMP, an amazing cohort course that will be a huge step up in your coding career - covering React, Next.js - next edition February 2025

Bootcamp 2025

Join the waiting list