Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
ALTER TABLE
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The ALTER TABLE
statement is certainly the most powerful among DDL statements, as tables are the most important object type in a database catalog.
Table of contents
- 3.4.1.4.1.
- ALTER TABLE .. ADD COLUMN
- 3.4.1.4.2.
- ALTER TABLE .. ADD COLUMNS
- 3.4.1.4.3.
- ALTER TABLE .. ADD COLUMN IF NOT EXISTS
- 3.4.1.4.4.
- ALTER TABLE .. ADD PRIMARY KEY
- 3.4.1.4.5.
- ALTER TABLE .. ADD UNIQUE
- 3.4.1.4.6.
- ALTER TABLE .. ADD FOREIGN KEY
- 3.4.1.4.7.
- ALTER TABLE .. ADD CHECK
- 3.4.1.4.8.
- ALTER TABLE .. RENAME
- 3.4.1.4.9.
- ALTER TABLE .. COMMENT
- 3.4.1.4.10.
- ALTER TABLE .. ALTER COLUMN .. SET DEFAULT
- 3.4.1.4.11.
- ALTER TABLE .. ALTER COLUMN .. SET NOT NULL
- 3.4.1.4.12.
- ALTER TABLE .. ALTER COLUMN .. DROP NOT NULL
- 3.4.1.4.13.
- ALTER TABLE .. ALTER COLUMN .. SET TYPE
- 3.4.1.4.14.
- ALTER TABLE .. RENAME COLUMN
- 3.4.1.4.15.
- ALTER TABLE .. RENAME CONSTRAINT
- 3.4.1.4.16.
- ALTER TABLE .. RENAME INDEX
- 3.4.1.4.17.
- ALTER TABLE .. DROP COLUMN
- 3.4.1.4.18.
- ALTER TABLE .. DROP COLUMN RESTRICT
- 3.4.1.4.19.
- ALTER TABLE .. DROP COLUMN CASCADE
- 3.4.1.4.20.
- ALTER TABLE .. DROP COLUMNS
- 3.4.1.4.21.
- ALTER TABLE .. ADD COLUMN IF NOT EXISTS
- 3.4.1.4.22.
- ALTER TABLE .. DROP CONSTRAINT
- 3.4.1.4.23.
- ALTER TABLE .. DROP PRIMARY KEY (new)
- 3.4.1.4.24.
- ALTER TABLE .. DROP FOREIGN KEY (new)
- 3.4.1.4.25.
- ALTER TABLE IF EXISTS
previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!