SYSTABLECONSTRAINTS

From Recital Documentation Wiki
Revision as of 12:07, 13 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

SYSTABLECONSTRAINTS

Class

SQL Applications


Purpose

Description of the constraints for each table available in the catalog


See Also

DATA TYPES, SELECT, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


Column Data Type Width Description
TABLE_CAT C 30 Table catalog
TABLE_SCHEM C 30 Table schema
TABLE_NAME C 30 Table name
CONSTRAINT_NAME C 30 Constraint name (see below)
CONSTRAINT C 100 Constraint


Constraint names:

  • CHECK
  • CLOSE
  • DELETE
  • ERROR
  • INSERT
  • OPEN
  • ROLLBACK
  • UPDATE


Example

EXEC SQL
SELECT *
FROM systableconstraints;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer