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 DATABASE PARTITION GROUP

Defines a new database partition group within the database, assigns database partitions to the database partition group, and records the database partition group definition in the system catalog.

CREATE EVENT MONITOR

Defines a monitor that records certain events that occur when you use the database. The definition of each event monitor also specifies where the database records the events.

CREATE EVENT MONITOR (activities)

Defines a monitor that will record activity events that occur when using the database.

CREATE EVENT MONITOR (change history)

Creates an event monitor that can record events for changes to configuration parameters, registry variables, and the execution of DDL statements and utilities.

CREATE EVENT MONITOR (locking)

Creates an event monitor that will record lock-related events that occur when using the database.

CREATE EVENT MONITOR (package cache)

Creates an event monitor that will record events when the cache entry for a section is flushed from the package cache.

CREATE FUNCTION (external scalar)

Registers a user-defined external scalar function

CREATE FUNCTION (external table)

Registers a user-defined 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)

Is used to define a user-defined SQL scalar, table, or row function.

A scalar function returns a single value each time it is invoked, and is generally valid wherever an SQL expression is valid. A table function can be used in a FROM clause and returns a table. A row function can be used as a transform function and returns a row

CREATE FUNCTION MAPPING

Defines a mapping between a federated database function or function template and a data source function, or disable a default mapping between a federated database function and a data source function.

CREATE GLOBAL TEMPORARY TABLE

Creates a description of a temporary table at the current server. Each session that selects from a created temporary table retrieves only rows that the same session has inserted. When the session terminates, the rows of the table associated with the session are deleted.

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

Used to define an index on a database table.

CREATE MASK

Creates a column mask at the current server. A column mask specifies the value to be returned for a specified column.

CREATE MODULE

Defines a module.

CREATE PERMISSION

Creates a row permission at the current server.

CREATE PROCEDURE (SQL)

Defines an SQL procedure at the current server.

CREATE ROLE

Defines a role at the current server.

CREATE SCHEMA

Defines a schema. It is also possible to create some objects and grant privileges on objects within the statement.

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

This statement can be embedded in an application program or issued through the use of dynamic SQL statements

CREATE SYNONYM

SYNONYM is a synonym for ALIAS.

CREATE TABLE

Defines a table.

CREATE Temporary TABLESPACE

Defines a table space

CREATE THRESHOLD

Defines a threshold.

CREATE TRUSTED CONTEXT

Defines a trusted context at the current server.

CREATE TYPE

Defines a user-defined structured type.

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 USAGE LIST

Defines a usage list. A usage list is a database object for monitoring all unique sections (DML statements) that have referenced a particular table or index during their execution

CREATE VARIABLE

Defines a session global variable.

CREATE VIEW

Defines a view on one or more tables, views or nicknames

CREATE WORK CLASS SET

Defines a work action set and work actions within the work action set

CREATE WORKLOAD

Defines a work class set

CREATE WRAPPER

Registers a wrapper with a federated server. A wrapper is a mechanism by which a federated server can interact with certain types of data sources.

CREATE WORK ACTION SET

Defines a work class set

ALTER AUDIT POLICY

Modifies the definition of an audit policy at the current server.

ALTER FUNCTION

Modifies the properties of an existing function.

ALTER HISTOGRAM TEMPLATE

Used to modify 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

Alters a column mask that exists at the current server.

ALTER MODULE

Changes the definition of a module

ALTER PACKAGE

Alters bind options for a package at the current server without having to bind or rebind the package

ALTER SEQUENCE

Used to change a sequence.

ALTER SERVICE CLASS

Alters the definition of a service class

ALTER TABLE

Changes the definition of a table.

ALTER TRIGGER

Changes the description of a trigger at the current server

ALTER TRUSTED CONTEXT

Used to add or drop attributes or method specifications of a user-defined structured type. Properties of existing methods can also be altered.

ALTER USAGE LIST

Alters the definition of a usage list.

ALTER WORKLOAD

Alters a workload.

ALTER WRAPPER

Used to update the properties of a wrapper

ALTER WORK CLASS SET

Adds, alters, or drops work classes within a work class set.

DROP TABLE

To drop a table

DROP VIEW

To drop View

DROP ALIAS

To drop Alias

DROP FUNCTION

To drop function in the BIGSQL schema

DROP TRIGGER

To drop trigger

DROP TYPE

To drop type

DROP EVENT MONITOR

To drop the event monitor.

DROP SCHEMA

Drop the schema under CREATE SCHEMA using RESTRICT.

DROP PROCEDURE

To drop procedure in the BIGSQL schema

DROP INDEX

Drop the index specification that was created to let the optimizer know about this index.

DROP SEQUENCE

Drop the sequence ORG_SEQ, with restrictions.

DROP PERMISSION

To drop permission

DROP MASK

To drop mask

DROP USAGE LIST

To drop usage List

RENAME TABLE

Renames an existing table or index

RENAME STOGROUP

Renames an existing storage group