Difference between revisions of "Using Recital SQL"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 16: | Line 16: | ||
* DELETE | * DELETE | ||
===Obtain Information about a Recital Table using SQL=== | ===Obtain Information about a Recital Table using SQL=== | ||
| − | SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row | + | * 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 | + | * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns |
| − | SYSCOLUMNPRIVILEGES Description of the access rights 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 | + | * SYSCOLUMNS Description of the table columns available in the catalog |
| − | SYSCROSSREFERENCE Description of how one table imports the keys of another table | + | * 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 | + | * 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 | + | * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key |
| − | SYSINDEXINFO Description of a table’s indices and statistics | + | * SYSINDEXINFO Description of a table’s indices and statistics |
| − | SYSPRIMARYKEYS Description of the primary key columns in the table | + | * SYSPRIMARYKEYS Description of the primary key columns in the table |
| − | SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog | + | * 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 | + | * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog |
| − | 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 |
===Summary=== | ===Summary=== | ||
Revision as of 10:55, 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
Inserting Records into a Recital Table using Recital SQL
- INSERT
Selecting Records from a Recital Table Using Recital SQL
- SELECT
Updating Records in a Recital Table using Recital SQL
- UPDATE
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
