SQL Statements

SQL statements perform data definition and manipulation tasks.

• ALTER DBSPACE Statement
  Changes the read/write mode, changes the size, or extends an existing dbspace.
• ALTER INDEX Statement
  Renames indexes in base or global temporary tables, foreign key role names of indexes and foreign keys explicitly created by a user, or changes the clustered nature of an index on a catalog store table. You cannot rename indexes created to enforce key constraints.
• ALTER LOGICAL SERVER Statement
  Modifies configuration for the existing user-defined logical server in the database. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• ALTER LS POLICY Statement
  Modifies some or all option values for the root logical server policy or a user-created logical server policy. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• ALTER TABLE Statement
  Modifies a table definition.
• CHECKPOINT Statement
  Checkpoints the database.
• COMMIT Statement
  Makes changes to the database permanent, or terminates a user-defined transaction.
• CREATE DATABASE Statement
  Creates a database consisting of several operating system files.
• CREATE DOMAIN Statement
  Creates a user-defined data type in the database.
• CREATE INDEX Statement
  Creates an index on a specified table, or pair of tables. Once an index is created, it is never referenced in an SQL statement again except to delete it using the DROP INDEX statement.
• CREATE LOGICAL SERVER Statement
  Creates a user-defined logical server. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• CREATE LS POLICY Statement
  Creates a user-defined logical server policy. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• CREATE TABLE Statement
  Creates a new table in the database or on a remote server.
• DROP Statement
  Removes objects from the database.
• DROP LOGICAL SERVER Statement
  Drops a user-defined logical server. This statement enforces consistent shared system temporary store settings across physical nodes shared by logical servers.
• GRANT INTEGRATED LOGIN Statement
  Creates an explicit integrated login mapping between one or more Windows user profiles and an existing database user ID. This allows a user who successfully logged in to their local machine to connect to a database without having to provide a user ID or password.
• IQ UTILITIES Statement
  Starts a cache monitor that collects buffer cache statistics.
• LOCK TABLE Statement
  Prevents other concurrent transactions from accessing or modifying a table within the specified time.
• ROLLBACK Statement
  Undoes any changes made since the last COMMIT or ROLLBACK.
• SAVEPOINT Statement
  Establishes a savepoint within the current transaction.
• SET OPTION Statement
  Changes options that affect the behavior of the database and its compatibility with Transact-SQL. Setting the value of an option can change the behavior for all users or an individual user, in either a temporary or permanent scope.
• STOP DATABASE Statement [Interactive SQL]
  Stops a database on the specified database server.