Using Recital SQL

From Recital Documentation Wiki
Revision as of 11:01, 16 December 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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

Summary