Difference between revisions of "SYSTABLECONSTRAINTS"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 32: | Line 32: | ||
|- | |- | ||
|} | |} | ||
| + | |||
Constraint names: | Constraint names: | ||
Revision as of 12:07, 13 March 2009
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
