PostgreSQL : SQL Commands : ALTER TABLE

Context of the notion in the technology: Document / Topc: PostgreSQL
Document / Topc: SQL Commands
Related Keywords: Postgre SQL SQL Commands ALTER TABLE
Help URL: http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html


Items Related to ALTER TABLE

Inner Elements of ALTER TABLE

ALTER TABLE contains following items:
  • ONLY
  • RENAME
  • COLUMN
  • SET
  • SCHEMA
  • ADD
  • DROP
  • RESTRICT
  • CASCADE
  • TYPE
  • USING
  • DEFAULT
  • NOT
  • NULL
  • STATISTICS
  • STORAGE
  • PLAIN
  • EXTERNAL
  • EXTENDED
  • MAIN
  • CONSTRAINT
  • DISABLE
  • TRIGGER
  • ALL
  • USER
  • ENABLE
  • CLUSTER
  • WITHOUT
  • OIDS
  • OWNER
  • TABLESPACE


PostgreSQL is a free object-relational database server (database management system), released under a flexible BSD-style license. It offers an alternative to other open-source database systems (such as MySQL and Firebird), as well as to proprietary systems such as Oracle, Sybase, IBM's DB2 and Microsoft SQL Server. Similar to other open-source projects such as Apache, Linux, and Mediawiki, PostgreSQL is not controlled by any single company, but relies on a global community of developers and companies to develop it.
   -- wikipedia.org
Home