Alter Table dan Column PostgreSQL, Oracle, MySQL

Material

Alter Table - PostgreSQL 8.1 Documentation http://www.postgresql.org/docs/8.1/static/sql-grant.html
Alter Table - PostgreSQL 9.3 Documentation http://www.postgresql.org/docs/9.3/static/sql-altertable.html

Langkah-langkah

Set Owner Tabel

PostgreSQL

ALTER TABLE tablename SET OWNER TO new_owner;

Ubah Nama Tabel dan Kolom

RENAME TABLE old_tablename TO new_tablename;
RENAME TABLE tablename RENAME old_columnname TO new_columnname;

Ubah Tipe Data Kolom

ALTER TABLE tablename ALTER COLUMN columnname TYPE new_datatype;

ubah kolom lebih dari satu
ALTER TABLE tablename
    ALTER COLUMN columnname TYPE new_datatype,
    ALTER COLUMN anothercolumn TYPE new_datatype;

ubah NOT NULL constraint
ALTER TABLE tablename ALTER COLUMN columnname SET|DROP NOT NULL;

Tambah dan Hapus Kolom

ALTER TABLE tablename ADD COLUMN columnname datatype;
ALTER TABLE tablename DROP COLUMN columnname;

Tambah dan Hapus Constraint

ALTER TABLE tablename ADD CONSTRAINT constraint_name PRIMARY KEY|FOREIGN KEY|UNIQUE
(column,column,..);
ALTER TABLE tablename DROP CONSTRAINT constraint_name;