Skip to content

SQL, how to update a table structure

How to update a SQL database table structure

THE AHA STACK MASTERCLASS

Launching May 27th

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

I wrote 20 books to help you become a better developer:

  • Astro Handbook
  • HTML Handbook
  • Next.js Pages Router Handbook
  • Alpine.js Handbook
  • HTMX Handbook
  • TypeScript Handbook
  • React Handbook
  • SQL Handbook
  • Git Cheat Sheet
  • Laravel Handbook
  • Express Handbook
  • Swift Handbook
  • Go Handbook
  • PHP Handbook
  • Python Handbook
  • Linux Commands Handbook
  • C Handbook
  • JavaScript Handbook
  • CSS Handbook
  • Node.js Handbook
...download them all now!

Related posts that talk about database: