Difference between revisions of "Using Recital SQL"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Selecting Records from a Recital Table Using Recital SQL) |
Yvonnemilne (Talk | contribs) (→Using Recital SQL) |
||
| Line 43: | Line 43: | ||
* SYSTABLES Description of the tables available in the catalog | * SYSTABLES Description of the tables available in the catalog | ||
* SYSTABLETYPES Table types available in the database system | * 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 | + | * 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=== | ===Summary=== | ||
Revision as of 11:04, 16 December 2009
Contents
- 1 Using Recital SQL
- 1.1 Creating a Recital Database
- 1.2 Opening a Recital Database
- 1.3 Creating a Recital Table using Recital SQL
- 1.4 Inserting Records into a Recital Table using Recital SQL
- 1.5 Selecting Records from a Recital Table Using Recital SQL
- 1.6 Updating Records in a Recital Table using Recital SQL
- 1.7 Deleting Records in a Recital Table using Recital SQL
- 1.8 Obtain Information about a Recital Table using SQL
- 1.9 Executing Procedures and Prepared Statements using Recital SQL
- 1.10 Summary
Using Recital SQL
Creating a Recital Database
- CREATE DATABASE
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
