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