Difference between revisions of "Using Recital SQL"
Barrymavin (Talk | contribs) (→Inserting Data into a Recital Table using Recital SQL) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Using Recital SQL== | ==Using Recital SQL== | ||
===Creating a Recital Database=== | ===Creating a Recital Database=== | ||
| + | * CREATE DATABASE | ||
===Opening a Recital Database=== | ===Opening a Recital Database=== | ||
| + | * OPEN DATABASE | ||
| + | * USE | ||
===Creating a Recital Table using Recital SQL=== | ===Creating a Recital Table using Recital SQL=== | ||
| + | * CREATE TABLE | ||
===Inserting Records into a Recital Table using Recital SQL=== | ===Inserting Records into a Recital Table using Recital SQL=== | ||
| − | + | * INSERT | |
===Selecting Records from a Recital Table Using Recital SQL=== | ===Selecting Records from a Recital Table Using Recital SQL=== | ||
| − | + | * SELECT | |
===Updating Records in a Recital Table using Recital SQL=== | ===Updating Records in a Recital Table using Recital SQL=== | ||
| − | + | * UPDATE | |
===Deleting Records in a Recital Table using Recital SQL=== | ===Deleting Records in a Recital Table using Recital SQL=== | ||
| − | + | * 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 | ||
| + | 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 | ||
===Summary=== | ===Summary=== | ||
Revision as of 10:53, 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
