Data definition statements

Data definition control support can control data definition statements.

The following data definition statements are controlled through the DB2® data definition control support.

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
 
DROP SYNONYM
Table
CREATE TABLE
ALTER TABLE
DROP TABLE
Table space
CREATE TABLESPACE
ALTER TABLESPACE
DROP TABLESPACE
View
CREATE VIEW
 
DROP VIEW

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