Data Definition Language (or DDL) includes those SQL statements that create and drop locations, databases and database objects such as tables and indexes. DDL also includes statements to alter database objects and impose integrity constraints on tables. All DDL statements automatically update the appropriate system catalog tables.
Changes information parameters for a database under the currently set XDB Server location.
Changes the configuration of an existing index (DB2). This command is supported syntactically by the XDB Server to maintain compatibility with DB2.
Converts a location to DB2 Version 4 or DB2 Version 5 compatibility.
Changes the attributes of a sequence at the current server.
Changes the specifications of an existing storage group (stogroup) defined within the current XDB Server location.
Adds, removes or renames table columns, or changes the data types of columns. In XDB mode, the ALTER TABLE command can create or drop UNIQUE, PRIMARY, FOREIGN KEY and CHECK constraints used to enforce referential and domain integrity, plus uniqueness (the DB2-specific syntax of the ALTER TABLE statement is supported in DB2 mode).
Changes the specifications of a table space within the currently set XDB Server location.
Regenerates a view using an existing view definition at the current server.
Places a remark about an object in the catalog tables at the currently set location.
The CREATE ALIAS command defines an alias for an existing table or view, and records the alias definition in the catalog tables at the currently set location. It is not required that the table or view be described under the same location as the alias.
Defines a logical database, which under default operating conditions consists of a subdirectory of the same name, under the active location root directory. The database directory, normally under the location root directory, holds the physical table and index files that are logically associated with the database. By using stogroups (described in the Server Administration Guide), users have the option of implicitly specifying different storage directories for individual database objects (or groups of objects).
Creates a description of a temporary table at the current server.
Creates an index on one or more columns of a table. Indexes speed data retrieval and can enforce uniqueness constraints.
Creates a new XDB Server location in a subdirectory path specified by the user. A location on an XDB Server is similar to a DB2 subsystem. In addition to a SYSTEM location (used for overall system administration and security), the XDB Server allows additional user-defined locations to be created.
Creates a sequence at the application server.
Creates a DB2 style storage group (stogroup) that can be associated with a directory path. Stogroups are used to define a physical directory area for storing database objects.
Creates an alternate name for a table or view within the currently set location.
Creates a table by defining all columns in the table, including the data type and field length of each column. Primary and Foreign keys for the table also can be created using this command.
Creates a DB2 style table space that can be used with a stogroup to store tables from the same logical database in different directory paths.
Defines a virtual table that usually restricts data retrieval and updating to a subset of columns and rows from one or more base tables.
Deletes an alternate name for a table or view from the location's system catalog.
Deletes a database defined within the current location. Also deletes all objects logically associated with the database, and then deletes the database subdirectory. If the database subdirectory is empty (with no objects logically associated with that database), then this command removes the empty subdirectory.
Deletes an index existing at the current location. Note that an index created as the result of a UNIQUE, PRIMARY or FOREIGN KEY constraint can only be dropped by first dropping the existing constraint with the ALTER command.
Removes a user-defined XDB Server location, along with accompanying catalog tables and directory structure. Also deletes all objects associated with the location.
Deletes a stogroup defined within the currently set location. This action severs the logical connection between any data objects that were defined using the stogroup, and the directory path specified in the deleted stogroup definition (does not delete objects associated with the stogroup) -- USE WITH CAUTION.
Deletes an alternate name for a table or view from the location's system catalog.
Deletes a table created under the current location, along with all associated indexes, views and synonyms built on that table.
Deletes a table space defined within the current location, along with all tables logically associated within that table space.
Deletes a view from the system catalog of the current location. In addition, all other views defined on the dropped view are dropped also.
Replaces or adds descriptive text labels to the catalog tables of the currently set location. These text labels describe tables, views, aliases, or columns existing at the current location.
Changes a table name.