NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-19
DDL (Data Definition Language) Statements
•
Relative and entry-sequenced files
Relative and entry-sequenced files always have the NO DCOMPRESS attribute,
although key compression has no effect on them.
DDL (Data Definition Language) Statements
DDL (Data Definition Language) is the set of SQL statements that define, delete, or
modify the SQL definition of an object or catalog. They can also change the
authorization to use an object or catalog.
DDL Statements
For more information about a specific DDL statement, see the entry for that statement.
Only one DDL statement can operate on a given SQL object (or partition of an SQL
object) at a time. An error occurs if you attempt to execute a DDL statement while
another process is executing a DDL statement on the same object. The specific error
depends on the statement involved and the phase of the operation at which the conflict
occurs.
Statement Description
ALTER CATALOG
Statement
Alters security for a catalog
ALTER COLLATION
Statement
Renames or alters security for a collation
ALTER INDEX
Statement
Renames, adds, drops, or moves partitions, or alters security or
other attributes of an index
ALTER PROGRAM
Statement
Renames or alters security of an SQL program in a Guardian file
ALTER TABLE
Statement
Renames, alters security of file attributes, or enables or disables
similarity checks for a table; also adds columns to a table and
adds, drops, or moves partitions of a table
ALTER VIEW
Statement
Renames, alters security, or enables or disables similarity checks
for a view; also adds column headings to a view
COMMENT Statement Writes a comment about an SQL object to a catalog
CONTINUE Statement Specifies a COMMIT option for a DDL operation ready to enter
its final phase
CREATE Creates a catalog, collation, constraint, index, table, or view
DROP Statement Drops a catalog, collation, constraint, index, SQL program in a
Guardian file, table, or view
HELP TEXT Statement Specifies help text for a column of a table or view
UPDATE STATISTICS
Statement
Updates statistics about the contents of a table and its indexes