Using Recital SQL

From Recital Documentation Wiki
Revision as of 14:47, 21 December 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Using Recital SQL

Creating a Recital Database

The create database statement is used to create a new database. This will create a sub-directory in the DB_DATADIR directory and a database catalog with the same name as the database specified.

create database [if not exists] <database name>
<code>
 
===Opening a Recital Database===
* OPEN DATABASE
* USE
===Creating a Recital Table using Recital SQL===
* CREATE TABLE
* ALTER TABLE
* ALTER INDEX
* CREATE INDEX
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* OPEN DATABASE
* USE
===Creating a Recital Table using Recital SQL===
* CREATE TABLE
* ALTER TABLE
* ALTER INDEX
* CREATE INDEX
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* USE
===Creating a Recital Table using Recital SQL===
* CREATE TABLE
* ALTER TABLE
* ALTER INDEX
* CREATE INDEX
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* CREATE TABLE
* ALTER TABLE
* ALTER INDEX
* CREATE INDEX
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* ALTER TABLE
* ALTER INDEX
* CREATE INDEX
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* ALTER INDEX
* CREATE INDEX
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* CREATE INDEX
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* TABLE CONSTRAINTS
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* COLUMN CONSTRAINTS
 
===Inserting Records into a Recital Table using Recital SQL===
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* INSERT
===Selecting Records from a Recital Table Using Recital SQL===
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SELECT
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* DECLARE CURSOR
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* OPEN
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* FETCH
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* DROP CURSOR
 
===Updating Records in a Recital Table using Recital SQL===
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* UPDATE
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* BEGIN...END TRANSACTION
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* COMMIT
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* ROLLBACK
===Deleting Records in a Recital Table using Recital SQL===
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* DELETE
===Obtain Information about a Recital Table using SQL===
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSBESTROWIDENTIFIER	Description of a table’s optimal set of columns that uniquely identifies a row
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSCOLUMNCONSTRAINTS	Description of the constraints for a table’s columns
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSCOLUMNPRIVILEGES	Description of the access rights for a table’s columns
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSCOLUMNS	Description of the table columns available in the catalog
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSCROSSREFERENCE	Description of how one table imports the keys of another table
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSEXPORTEDKEYS	Description of the foreign key columns that reference the primary key columns
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSIMPORTEDKEYS	Description of the primary key columns that are referenced by the foreign key
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSINDEXINFO	Description of a table’s indices and statistics
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSPRIMARYKEYS	Description of the primary key columns in the table
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSTABLECONSTRAINTS	Description of the constraints for each table available in the catalog
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSTABLEPRIVILEGES	Description of the access rights for each table available in the catalog
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSTABLES	Description of the tables available in the catalog
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSTABLETYPES	Table types available in the database system
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSVERSIONCOLUMNS	Description of the columns in a table that are automatically updated when any row is updated
===Executing Procedures and Prepared Statements using Recital SQL===
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* CREATE PROCEDURE
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* DROP PROCEDURE
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* EXECUTE
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* EXECUTE IMMEDIATE
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* PREPARE
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary=
* SYSRESULTSET Used to return the singleton result from any Recital expression  
===Summary===