ajpenalosa
6/18/2018 - 2:36 AM

Alter Table

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

https://www.w3schools.com/sql/sql_alter.asp

ALTER TABLE programming_languages
ADD mastered BOOLEAN DEFAULT FALSE;
ALTER TABLE table_name
CHANGE COLUMN column_name
column_name BOOLEAN NOT NULL DEFAULT TRUE;