SQL CREATE ALTER DROP VIEW

Internal

• SQL
• SQL Data Types

CREATE

CREATE TABLE cust_view AS 
SELECT id, name, address FROM customer;

PostgreSQL

MySQL

ALTER

ALTER TABLE person [...]

Add/Remove a Column

ALTER TABLE person ADD COLUMN birthday DATE;

PostgreSQL

MySQL

DROP

DROP TABLE person [...]

PostgreSQL

MySQL

Features

AUTO_INCREMENT

AUTO_INCREMENT