Adding and deleting columns

Add a new column to the table and then delete it.


We assume that you already created tables in step Creating a table and populated them with data in step Adding data to a table.

Adding a column

Add a non-key column to the existing table:

ALTER TABLE episodes ADD COLUMN viewers Uint64;

Deleting a column

Delete the column you added from the table:

ALTER TABLE episodes DROP COLUMN viewers;