Difference between revisions of "Using Recital SQL"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 7: | Line 7: | ||
===Creating a Recital Table using Recital SQL=== | ===Creating a Recital Table using Recital SQL=== | ||
* CREATE TABLE | * CREATE TABLE | ||
| + | * ALTER TABLE | ||
| + | * ALTER INDEX | ||
| + | * CREATE INDEX | ||
===Inserting Records into a Recital Table using Recital SQL=== | ===Inserting Records into a Recital Table using Recital SQL=== | ||
* INSERT | * INSERT | ||
| Line 13: | Line 16: | ||
===Updating Records in a Recital Table using Recital SQL=== | ===Updating Records in a Recital Table using Recital SQL=== | ||
* UPDATE | * UPDATE | ||
| + | * BEGIN...END TRANSACTION | ||
| + | * COMMIT | ||
| + | * ROLLBACK | ||
===Deleting Records in a Recital Table using Recital SQL=== | ===Deleting Records in a Recital Table using Recital SQL=== | ||
* DELETE | * DELETE | ||
Revision as of 10:58, 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
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
- 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
