The ALTER statement

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

ALTER statements are used to alter properties of existing objects in the database catalog.

Table of contents

4.6.1.1.

ALTER DATABASE

4.6.1.2.

ALTER DOMAIN

4.6.1.3.

ALTER INDEX

4.6.1.4.

ALTER SCHEMA

4.6.1.5.

ALTER SEQUENCE

4.6.1.6.

ALTER TABLE

4.6.1.7.

ALTER TYPE

4.6.1.7.1.

ALTER TYPE .. RENAME

4.6.1.7.2.

ALTER TYPE .. for enum alterations

4.6.1.8.

ALTER VIEW

4.6.1.8.1.

ALTER VIEW .. COMMENT

4.6.1.8.2.

ALTER VIEW .. RENAME

4.6.1.8.3.

ALTER VIEW IF EXISTS