SQL Cheat Sheet :: Data Definition Language
Create New Table Structure
MySQL
PostgreSQL
MSSQL
Oracle
Add New Column to Existing Table
MySQL
PostgreSQL
MSSQL
ALTER TABLE table-name ADD column-name
{ type_name [ ( prec [, scale] ) ] [COLLATE <collation name> ]
[ NULL | NOT NULL ] }
Oracle
Modify Existing Column in Existing Table
MySQL
PostgreSQL
alter table t_friend_relation rename column friend_ui to friend_uid;
MSSQL
ALTER TABLE table-name ALTER COLUMN column-name
{ type_name [ ( prec [, scale] ) ] [COLLATE <collation name> ]
[ NULL | NOT NULL ] | {ADD | DROP} ROWGUIDCOL }