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

add-column
content_copyfile_download
ALTER TABLE programming_languages
ADD mastered BOOLEAN DEFAULT FALSE;
change-column
content_copyfile_download
ALTER TABLE table_name
CHANGE COLUMN column_name
column_name BOOLEAN NOT NULL DEFAULT TRUE;