Title - ALTER SQL statements Tags - sqlstatements
The ALTER TABLE statement adds a new column to a table.
Example:
ALTER TABLE celebs ADD COLUMN twitter_handle TEXT;
ALTER TABLE is a clause to make specified changes.
celebs is the name of the table being changed.
ADD COLUMN is a clause to add a new column to the table.
twitter_handle is the name of the new column.
TEXT is the data type for the new column.