SYSTABLECONSTRAINTS
From Recital Documentation Wiki
Contents
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
SELECT * FROM systableconstraints
Products
Recital, Recital Server
