SYSTABLECONSTRAINTS
From Recital Documentation Wiki
Revision as of 12:07, 13 March 2009 by Yvonnemilne (Talk | contribs)
Contents
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
