Tables

create

create table [if not exists] table-name (
    field-name data-type [(size)] [not null],
    ...
);

alter

• Adding, changing, or deleting a column
  

alter table table-name
    add column column-definition [first, after col_name];
  | drop column column-name;
    ...
  | add index index-name index-type (index-col-name, ...);
  | drop index index-name;

drop

drop table [if exists] table-name;

rename

rename table table-name to new-table-name;