Difference between revisions of "Using Recital SQL"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Creating a Recital Table using Recital SQL) |
Yvonnemilne (Talk | contribs) (→Selecting Records from a Recital Table Using Recital SQL) |
||
| Line 17: | Line 17: | ||
===Selecting Records from a Recital Table Using Recital SQL=== | ===Selecting Records from a Recital Table Using Recital SQL=== | ||
* SELECT | * SELECT | ||
| + | * DECLARE CURSOR | ||
| + | * OPEN | ||
| + | * FETCH | ||
| + | * DROP CURSOR | ||
| + | |||
===Updating Records in a Recital Table using Recital SQL=== | ===Updating Records in a Recital Table using Recital SQL=== | ||
* UPDATE | * UPDATE | ||
Revision as of 11:01, 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 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
