We have started to CREATE database objects.

  CREATE object_type object_name
  [AS structure]

So far we are making (CREATE),

  CREATE TABLE table_name
  (
    field1 datatype [null|not null] [unique] [primary key],
    field2 datatype [null|not null],
    ...
  )

modifying (ALTER)

  ALTER TABLE table_name
  ADD|DROP|ALTER COLUMN field_name datatype

and destroying (DROP) tables.

  DROP TABLE table_name

Download the class notes for day 6.