SQL CREATE ALTER DROP TABLE

Internal

• SQL
• SQL Data Types

CREATE

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

PostgreSQL

MySQL

ALTER

ALTER TABLE person [...]

PostgreSQL

MySQL

DROP

DROP TABLE person [...]

PostgreSQL

MySQL