Skip to content

SQL, how to update a table structure

FULL-STACK WEB DEVELOPMENT BOOTCAMP

2024 COHORT SIGNUPS END TOMORROW

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
  • Learn modern web development in my BOOTCAMP (SIGNUP END TOMORROW FEB 20, 2024)
  • THE VALLEY OF CODE (+ PRO), your web development manual
  • I wrote 15+ coding BOOKS, all available in THE VALLEY OF CODE PRO
  • Indie solopreneur internet business masterclass SOLO LAB (summer 2024)