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.1.1.

ALTER DATABASE .. RENAME

4.6.1.1.2.

ALTER DATABASE IF EXISTS

4.6.1.2.

ALTER DOMAIN

4.6.1.2.1.

ALTER DOMAIN .. RENAME

4.6.1.2.2.

ALTER DOMAIN .. SET DEFAULT

4.6.1.2.3.

ALTER DOMAIN .. DROP DEFAULT

4.6.1.2.4.

ALTER DOMAIN .. SET NOT NULL

4.6.1.2.5.

ALTER DOMAIN .. DROP NOT NULL

4.6.1.2.6.

ALTER DOMAIN .. ADD CONSTRAINT

4.6.1.2.7.

ALTER DOMAIN .. RENAME CONSTRAINT

4.6.1.2.8.

ALTER DOMAIN .. RENAME CONSTRAINT IF EXISTS

4.6.1.2.9.

ALTER DOMAIN .. DROP CONSTRAINT

4.6.1.2.10.

ALTER DOMAIN .. DROP CONSTRAINT IF EXISTS

4.6.1.2.11.

ALTER DOMAIN IF EXISTS

4.6.1.3.

ALTER INDEX

4.6.1.3.1.

ALTER INDEX .. RENAME

4.6.1.3.2.

ALTER INDEX IF EXISTS

4.6.1.4.

ALTER SCHEMA

4.6.1.4.1.

ALTER SCHEMA .. RENAME

4.6.1.4.2.

ALTER SCHEMA IF EXISTS

4.6.1.5.

ALTER SEQUENCE

4.6.1.5.1.

ALTER SEQUENCE .. RENAME

4.6.1.5.2.

ALTER SEQUENCE .. CACHE

4.6.1.5.3.

ALTER SEQUENCE .. CYCLE

4.6.1.5.4.

ALTER SEQUENCE .. MINVALUE

4.6.1.5.5.

ALTER SEQUENCE .. t reaches its MAXVALUE

4.6.1.5.6.

ALTER SEQUENCE .. INCREMENT BY

4.6.1.5.7.

ALTER SEQUENCE .. START WITH

4.6.1.5.8.

ALTER SEQUENCE .. RESTART

4.6.1.5.9.

ALTER SEQUENCE IF EXISTS

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.7.3.

ALTER TYPE IF EXISTS (new)

4.6.1.8.

ALTER VIEW

4.6.1.8.1.

ALTER VIEW .. AS

4.6.1.8.2.

ALTER VIEW .. COMMENT

4.6.1.8.3.

ALTER VIEW .. RENAME

4.6.1.8.4.

ALTER VIEW IF EXISTS