SQL CREATE ALTER DROP VIEW

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

Internal

Overview

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