SQL CREATE ALTER DROP TABLE

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

CREATE

CREATE TABLE person 
( id smallint, 
  name varchar(30), 
  CONSTRAINT pk_person PRIMARY KEY (id)
);
PostgreSQL MariaDB


  • Refactor MySQL DDL Operations and surface in "Standard SQL" everything that can be handled with standard SQL.

ALTER

DROP