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

Retrieved from "https://kb.novaordis.com/index.php?title=SQL_CREATE_ALTER_DROP_TABLE&oldid=110544"