The following commands are presented in this section.
ALTER TABLE ALTER TABLE adds or removes columns from a specified table. The default insertion value may also be changed. ALTER TABLE is not supported by transaction processing and cannot be undone.
COMMIT COMMIT is provided for syntactic compatibility only. COMMIT and ROLLBACK functionality is automatically supported by ISQL and ODBC. By default, both ISQL and ODBC automatically commit transactions at the end of every statement. This can be changed from ODBC only by making appropriate ODBC calls to initiate a manual transaction.
CREATE INDEX CREATE INDEX creates an index on the specified table for the specified column(s).
CREATE TABLE CREATE TABLE creates a new D3 file and an SQL mapping. For each column specified in the CREATE TABLE statement, an attribute-defining item is created.
DELETE DELETE deletes rows in the specified table that meet the search condition. The basic syntax for the DELETE statement involves simple search conditions which may delete zero to many rows from the table.
DROP INDEX DROP INDEX removes the named index from the specified table.
DROP TABLE DROP TABLE removes the specified table and frees up internal storage used by the data. Both the SQL table and the D3 file are removed.
INSERT INSERT inserts new rows into the specified table. The syntax below inserts a single row into the table. (An alternative syntax is described later in this section.)
ROLLBACK ROLLBACK is provided for syntactic compatibility only. COMMIT and ROLLBACK functionality is supported automatically by ISQL and ODBC. By default, both ISQL and ODBC automatically commit transactions at the end of every statement. This can be changed from ODBC only by making appropriate ODBC calls to initiate a manual transaction.
SET TRANSACTION SET TRANSACTION sets the characteristics of all subsequent transactions on the system.
UPDATE UPDATE modifies zero to many rows in the database. Rows which meet the search_condition are modified based on the column_name = expression list. An UPDATE operation may not modify a nested or primary key.