← Back
LESSON 17
SQL (Core) - Altering tables
Prereq: None | Progress: 0%
Course Syllabus
Lesson 0 📖 What is SQL? Lesson 1 📖 SELECT queries 101 Lesson 2 📖 Queries with constraints (Pt. 1) Lesson 3 📖 Queries with constraints (Pt. 2) Lesson 4 📖 Filtering & sorting results Review 1 📖 Simple SELECT Queries Lesson 6 📖 Multi-table queries with JOINs Lesson 7 📖 OUTER JOINs Lesson 8 📖 A short note on NULLs Lesson 9 📖 Queries with expressions Lesson 10 📖 Queries with aggregates (Pt. 1) Lesson 11 📖 Queries with aggregates (Pt. 2) Lesson 12 📖 Order of execution of a Query Lesson 13 📖 Inserting rows Lesson 14 📖 Updating rows Lesson 15 📖 Deleting rows Lesson 16 📖 Creating tables Lesson 17 📖 Altering tables Lesson 18 📖 Dropping tables Lesson 19 📖 Subqueries & Nested Queries Lesson 20 📖 Set Operations Summary 🎓 Course Completion
SQL Lesson 17: Altering tables
As business requirements change, database structures must evolve. The ALTER TABLE statement modifies table structures without requiring you to drop and recreate existing data.
Adding Columns & Renaming Tables
-- Add a new column with a default value
ALTER TABLE movies ADD COLUMN rating FLOAT DEFAULT 0.0;
-- Rename table
ALTER TABLE movies RENAME TO pixar_films;
🗄️ Schema Explorer SELECTABLE
› movies
|
🎯 Exercises Checklist:
☐ 1. Add a column named Aspect_ratio with a FLOAT data type to store aspect ratios
☐ 2. Add a column named Language with a TEXT data type with default value English
⚡ Practice Console
💡 Hint:
Loading hint...
🔑 Solution SQL:
SELECT * FROM movies;Data Output
No results. Run query to fetch data.