The 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:

  • blood_group is the name of the new column being added.
  • TEXT is the data type for the new column.