sql:ddl [JM Knowledge Base]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== SQL Cheat Sheet :: Data Definition Language ======
===== Create New Table Structure =====
==== MySQL ====
==== PostgreSQL ====
==== MSSQL ====
==== Oracle ====

===== Add New Column to Existing Table =====

==== MySQL ====
==== PostgreSQL ====
==== MSSQL ====
<code>
ALTER TABLE table-name ADD column-name
    { type_name [ ( prec [, scale] ) ] [COLLATE <collation name> ]
    [ NULL | NOT NULL ] }
</code>

==== Oracle ====

===== Modify Existing Column in Existing Table =====
==== MySQL ====
==== PostgreSQL ====
<code>
alter table t_friend_relation rename column friend_ui to friend_uid;
</code>
==== MSSQL ====
<code>
ALTER TABLE table-name ALTER COLUMN column-name
    { type_name [ ( prec [, scale] ) ] [COLLATE <collation name> ]
    [ NULL | NOT NULL ] | {ADD | DROP} ROWGUIDCOL }
</code>

==== Oracle ====