Filter
Top Products
DescriptionSQL Statement
Inserts rows of data into a table or view.INSERT
Locks the specified table (or underlying tables of a view)
and its associated indexes for the duration of the active
transaction.
LOCK TABLE
Performs one or more table maintenance tasks, such as
REORG, UPDATE STATISTICS, and REFRESH, on a
specified database object.
MAINTAIN
Loads a specified index with data from a specified table.POPULATE INDEX
Compiles an SQL statement for later use with the
EXECUTE statement.
PREPARE
Deletes all data from a table and its related indexes.PURGEDATA
Reorganizes data in a table or index and compacts space
needed for rows by removing unused space.
REORG
Revokes access privileges for a table or view from specified
users.
REVOKE
Undoes all modifications to database objects during the
current transaction, releases all locks on database objects
held by the transaction, and ends the transaction.
ROLLBACK WORK
Retrieves data from tables, views, derived tables
determined by the evaluation of query expressions, or
joined tables.
SELECT
Sets the schema name for unqualified object names for the
current session.
SET SCHEMA
Sets a dynamic timeout value for a lock timeout or a stream
timeout in the environment of the current session.
SET TABLE TIMEOUT
Sets attributes, such as isolation level and access mode,
for the next transaction.
SET TRANSACTION
Updates data in a row or rows of a table or updateable
view.
UPDATE
Updates histogram statistics for one or more groups of
columns in a table.
UPDATE STATISTICS
134 Supported SQL Statements