By Hemanta Sundaray on 2022-12-17
ALTER TABLE statement adds a new column to a table. You can use this command when you want to add columns to a table.
The statement below adds a new column
blood_group to the students table.
ALTER TABLE students ADD COLUMN blood_group TEXT;
ALTER TABLE is a clause that lets you make the specified changes. students is the name of the table that is being changed. ADD COLUMN is a clause that lets you add a new column to a table: