Statements controlled by data definition control support

Data definition control support can control data definition statements.

Db2 data definition control support controls the following data definition statements.

Table 1. Data definition Statements
Object CREATE statement ALTER statement DROP statement
Alias CREATE ALIAS   DROP ALIAS
Database CREATE DATABASE ALTER DATABASE DROP DATABASE
Index CREATE INDEX ALTER INDEX DROP INDEX
Storage group CREATE STOGROUP ALTER STOGROUP DROP STOGROUP
Synonym CREATE SYNONYM 1   DROP SYNONYM
Table CREATE TABLE ALTER TABLE DROP TABLE
Table space CREATE TABLESPACE ALTER TABLESPACE DROP TABLESPACE
View CREATE VIEW   DROP VIEW
Note:
  1. Beginning in Db2 12, packages bound with APPLCOMPAT(V12R1M504) or higher cannot issue CREATE SYNONYM statements.

The data definition control support also controls the COMMENT and LABEL statements.