The following example create the adult table:

CREATE TABLE adult
  (member_no     member_no     NOT NULL,
   lastname      shortstring   NOT NULL,
   firstname     shortstring   NOT NULL,
   middleinitial letter        NULL,
   photograph    image         NULL)


The following example adds a column that allows NULL's:

ALTER TABLE sales
  ADD commission money null


The following example modifies a table in order to drop a column:

ALTER TABLE sales
  DROP COLUMN customer_name

The following example dros the adult table:

DROP TABLE adult