CREATE, ALTER, DROP

-- Create table
CREATE TABLE table_name (
   column_1 data_type, 
   column_2 data_type, 
   column_3 data_type
);

-- Create table with constraints
CREATE TABLE celebs (
   id INTEGER PRIMARY KEY, 
   name TEXT UNIQUE,
   date_of_birth TEXT NOT NULL,
   date_of_death TEXT DEFAULT 'Not Applicable'
);

-- Alter table
ALTER TABLE celebs 
ADD COLUMN twitter_handle TEXT;

-- Empty table
TRUNCATE venues CASCADE;

-- Drop table
DROP TABLE table_name;

-- Rename table
ALTER TABLE old_name RENAME TO new_name;