| SQL Statement |
Purpose |
| ALTER AUDIT POLICY |
Modifies the definition of an audit policy at the current server. |
| ALTER BUFFERPOOL |
Changes the definition of a buffer pool. |
| ALTER DATABASE |
Adds new storage paths to the collection of paths that are used for automatic storage tablespaces. |
| ALTER EVENT MONITOR |
Changes the definition of a TABLE or UNFORMATTED EVENT TABLE event monitor. |
| ALTER DATABASE PARTITION GROUP |
Changes the definition of a database partition group. |
| ALTER FUNCTION |
Modifies an existing function by changing the properties of the function. |
| ALTER HISTOGRAM TEMPLATE |
Modifies the template describing the type of histogram that can be used to override one or more of the default histograms of a service class or a work class. |
| ALTER INDEX |
Changes the definition of an index. |
| ALTER MASK |
Changes the definition of a column mask. |
| ALTER METHOD |
Modifies an existing method by changing the method body associated with the method. |
| ALTER MODULE |
Changes the definition of a module. |
| ALTER NICKNAME |
Changes the definition of a nickname. |
| ALTER PACKAGE |
Alters bind options for a package at the current server without having to bind or rebind the package. |
| ALTER PERMISSION |
Changes the definition of a row permission. |
| ALTER PROCEDURE (external) |
Modifies an existing external procedure by changing the properties of the procedure. |
| ALTER PROCEDURE (sourced) |
Modifies an existing sourced procedure by changing the data type of one or more parameters of the sourced procedure. |
| ALTER PROCEDURE (SQL) |
Modifies an existing SQL procedure by changing the properties of the procedure. |
| ALTER SCHEMA |
Modifies an existing schema by changing the data capture attribute of the schema. |
| ALTER SECURITY LABEL COMPONENT |
Modifies a security label component. |
| ALTER SECURITY POLICY |
Modifies a security policy. |
| ALTER SEQUENCE |
Changes the definition of a sequence. |
| ALTER SERVER |
Changes the definition of a data source in a federated system. |
| ALTER SERVICE CLASS |
Changes the definition of a service class. |
| ALTER STOGROUP |
Changes the definition of a storage group. |
| ALTER TABLE |
Changes the definition of a table. |
| ALTER TABLESPACE |
Changes the definition of a table space. |
| ALTER THRESHOLD |
Changes the definition of a threshold. |
| ALTER TRIGGER |
Changes the definition of a trigger. |
| ALTER TRUSTED CONTEXT |
Changes the definition of a trusted context at the current server. |
| ALTER TYPE (structured) |
Changes the definition of a structured type. |
| ALTER USAGE LIST |
Changes the definition of a usage list. |
| ALTER USER MAPPING |
Changes the definition of a user authorization mapping. |
| ALTER VIEW |
Changes the definition of a view by altering a reference type column to add a scope. |
| ALTER WORK ACTION SET |
Adds, alters, or drops work actions within a work action set. |
| ALTER WORK CLASS SET |
Adds, alters, or drops work classes within a work class set. |
| ALTER WORKLOAD |
Changes a workload. |
| ALTER WRAPPER |
Updates the options that, along with a wrapper module, are used to access data sources of a specific type. |
| ALTER XSROBJECT |
Enables or disables decomposition support for a specific XML schema. |
| AUDIT |
Determines the audit policy that is to be used for a particular database or database object at the current server. |
| COMMENT |
Replaces or adds a comment to the description of an object. |
| CREATE ALIAS |
Defines an alias for a module, nickname, sequence, table, view, or another alias. |
| CREATE AUDIT POLICY |
Defines an auditing policy at the current server. |
| CREATE BUFFERPOOL |
Defines a new buffer pool. |
| CREATE DATABASE PARTITION GROUP |
Defines a database partition group. |
| CREATE EVENT MONITOR |
Specifies events in the database to monitor. |
| CREATE EVENT MONITOR (activities) |
Specifies activity events in the database to monitor. |
| CREATE EVENT MONITOR (change history) |
Specifies change history events in the database to monitor. |
| CREATE EVENT MONITOR (locking) |
Specifies locking events in the database to monitor. |
| CREATE EVENT MONITOR (package cache) |
Specifies package cache statement events in the database to monitor. |
| CREATE EVENT MONITOR (statistics) |
Specifies statistics events in the database to monitor. |
| CREATE EVENT MONITOR (threshold violations) |
Specifies threshold violation events in the database to monitor. |
| CREATE FUNCTION |
Registers a user-defined function. |
| CREATE FUNCTION |
Registers a user-defined function. |
| CREATE FUNCTION (aggregate interface) |
Registers a user-defined aggregate function at the current server. |
| CREATE FUNCTION (external scalar) |
Registers a user-defined external scalar function. |
| CREATE FUNCTION (external table) |
Registers a user-defined external table function. |
| CREATE FUNCTION (OLE DB external table) |
Registers a user-defined OLE DB external table function. |
| CREATE FUNCTION (sourced or template) |
Registers a user-defined sourced function or a function template. |
| CREATE FUNCTION (SQL scalar, table, or row) |
Defines a user-defined SQL function. |
| CREATE FUNCTION MAPPING |
Defines a function mapping. |
| CREATE GLOBAL TEMPORARY TABLE |
Defines a created temporary table. |
| CREATE HISTOGRAM TEMPLATE |
Defines a template describing the type of histogram that can be used to override one or more of the default histograms of a service class or a work class. |
| CREATE INDEX |
Defines an index on a table. |
| CREATE INDEX EXTENSION |
Defines an extension object for use with indexes on tables with structured or distinct type columns. |
| CREATE MASK |
Defines a column mask. |
| CREATE METHOD |
Defines a method body to associate with a previously defined method specification. |
| CREATE MODULE |
Defines a module. |
| CREATE NICKNAME |
Defines a nickname. |
| CREATE PERMISSION |
Defines a row permission. |
| CREATE PROCEDURE |
Defines a procedure. |
| CREATE PROCEDURE (external) |
Defines an external procedure. |
| CREATE PROCEDURE (sourced) |
Defines a procedure (the sourced procedure) that is based on another procedure (the source procedure).
In a federated system, a federated procedure is a sourced procedure whose source procedure is at a supported data source. |
| CREATE PROCEDURE (SQL) |
Defines an SQL procedure. |
| CREATE ROLE |
Defines a role at the current server. |
| CREATE SCHEMA |
Defines a schema. |
| CREATE SECURITY LABEL COMPONENT |
Defines a component that is to be used as part of a security policy. |
| CREATE SECURITY LABEL |
Defines a security label. |
| CREATE SECURITY POLICY |
Defines a security policy. |
| CREATE SEQUENCE |
Defines a sequence. |
| CREATE SERVER |
Defines a data source to a federated database. |
| CREATE SERVICE CLASS |
Defines a service class. |
| CREATE STOGROUP |
Defines a new storage group within the database. |
| CREATE SYNONYM |
Defines a synonym for a module, nickname, sequence, table, view, or another synonym. |
| CREATE TABLE |
Defines a table. |
| CREATE TABLESPACE |
Defines a table space. |
| CREATE THRESHOLD |
Defines a threshold. |
| CREATE TRANSFORM |
Defines transformation functions. |
| CREATE TRIGGER |
Defines a trigger. |
| CREATE TRUSTED CONTEXT |
Defines a trusted context at the current server. |
| CREATE TYPE |
Defines a user-defined data type at the current server. |
| CREATE TYPE (array) |
Defines an array type. |
| CREATE TYPE (cursor) |
Defines a cursor type. |
| CREATE TYPE (distinct) |
Defines a distinct data type. |
| CREATE TYPE (row) |
Defines a row type. |
| CREATE TYPE (structured) |
Defines a structured data type. |
| CREATE TYPE MAPPING |
Defines a mapping between data types. |
| CREATE USAGE LIST |
Defines a usage list in order to monitor all unique sections (DML statements) that have referenced a particular table or index during their execution. |
| CREATE USER MAPPING |
Defines a mapping between user authorizations. |
| CREATE VARIABLE |
Defines a global variable. |
| CREATE VIEW |
Defines a view of one or more table, view or nickname. |
| CREATE WORK ACTION SET |
Defines a work action set and work actions within the work action set. |
| CREATE WORK CLASS SET |
Defines a work class set. |
| CREATE WORKLOAD |
Defines a workload. |
| CREATE WRAPPER |
Registers a wrapper. |
| DROP |
Deletes objects in the database. |
| GRANT (database authorities) |
Grants authorities on the entire database. |
| GRANT (exemption) |
Grants an exemption on an access rule for a specified label-based access control (LBAC) security policy. |
| GRANT (global variable privileges) |
Grants one or more privileges on a created global variable. |
| GRANT (index privileges) |
Grants the CONTROL privilege on indexes in the database. |
| GRANT (module privileges) |
Grants privileges on a module. |
| GRANT (package privileges) |
Grants privileges on packages in the database. |
| GRANT (role) |
Grants roles to users, groups, or to other roles. |
| GRANT (routine privileges) |
Grants privileges on a routine (function, method, or procedure). |
| GRANT (schema privileges) |
Grants privileges on a schema. |
| GRANT (security label) |
Grants a label-based access control (LBAC) security label for read access, write access, or for both read and write access. |
| GRANT (sequence privileges) |
Grants privileges on a sequence. |
| GRANT (server privileges) |
Grants privileges to query a specific data source. |
| GRANT (SETSESSIONUSER privilege) |
Grants the privilege to use the SET SESSION AUTHORIZATION statement. |
| GRANT (table space privileges) |
Grants privileges on a table space. |
| GRANT (table, view, or nickname privileges) |
Grants privileges on tables, views and nicknames. |
| GRANT (workload privileges) |
Grants the USAGE privilege on a workload. |
| GRANT (XSR object privileges) |
Grants the USAGE privilege on an XSR object. |
| REFRESH TABLE |
Refreshes the data in a materialized query table. |
| RENAME |
Renames an existing table. |
| RENAME STOGROUP |
Renames an existing storage group. |
| RENAME TABLESPACE |
Renames an existing table space. |
| REVOKE (database authorities) |
Revokes authorities from the entire database. |
| REVOKE (exemption) |
Revokes the exemption on an access rule for a specified label-based access control (LBAC) security policy. |
| REVOKE (global variable privileges) |
Revokes one or more privileges on a created global variable. |
| REVOKE (index privileges) |
Revokes the CONTROL privilege on given indexes. |
| REVOKE (module privileges) |
Revokes privileges on a module. |
| REVOKE (package privileges) |
Revokes privileges from given packages in the database. |
| REVOKE (role) |
Revokes roles from users, groups, or other roles. |
| REVOKE (routine privileges) |
Revokes privileges on a routine (function, method, or procedure). |
| REVOKE (schema privileges) |
Revokes privileges on a schema. |
| REVOKE (security label) |
Revokes a label-based access control (LBAC) security label for read access, write access, or for both read and write access. |
| REVOKE (sequence privileges) |
Revokes privileges on a sequence. |
| REVOKE (server privileges) |
Revokes privileges to query a specific data source. |
| REVOKE (SETSESSIONUSER privilege) |
Revokes the privilege to use the SET SESSION AUTHORIZATION statement. |
| REVOKE (table space privileges) |
Revokes the USE privilege on a given table space. |
| REVOKE (table, view, or nickname privileges) |
Revokes privileges from given tables, views or nicknames. |
| REVOKE (workload privileges) |
Revokes the USAGE privilege on a workload. |
| REVOKE (XSR object privileges) |
Revokes the USAGE privilege on an XSR object. |
| SET INTEGRITY |
Sets the set integrity pending state and checks data for constraint violations. |
| TRANSFER OWNERSHIP |
Transfers ownership of a database object. |
