Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Manipulation

Alter

ALTER TABLE celebs ADD COLUMN twitter_handle TEXT;

The ALTER TABLE statement added a new column to the table. You can use this command when you want to add columns to a table.

1. ALTER TABLE is a clause that lets you make the specified changes.
2. celebs is the name of the table that is being changed.
3. ADD COLUMN is a clause that lets you add a new column to a table.

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


4. NULL is a special value in SQL that represents missing or unknown data. Here, the rows that existed before the column was added have NULL values for twitter_handle.

Report a Bug
If you see a bug or any other issue with this page, please report it here.