System Views
Go Up to System Tables, Temporary Tables, and Views
You can create a SQL script using the code provided in this section to create four views that provide information about existing integrity constraints for a database. You must create the database prior to creating these views. SQL system views are a subset of system views defined in the SQL-92 standard. Since they are defined by ANSI SQL-92, the names of the system views and their columns do not start with RDB$
.
- The
CHECK_CONSTRAINTS
view:
CREATE VIEW CHECK_CONSTRAINTS ( CONSTRAINT_NAME, CHECK_CLAUSE ) AS SELECT RDB$CONSTRAINT_NAME, RDB$TRIGGER_SOURCE FROM RDB$CHECK_CONSTRAINTS RC, RDB$TRIGGERS RT WHERE RT.RDB$TRIGGER_NAME = RC.RDB$TRIGGER_NAME;
- The
CONSTRAINTS_COLUMN_USAGE
view:
CREATE VIEW CONSTRAINTS_COLUMN_USAGE ( TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME ) AS SELECT RDB$RELATION_NAME, RDB$FIELD_NAME, RDB$CONSTRAINT_NAME FROM RDB$RELATION_CONSTRAINTS RC, RDB$INDEX_SEGMENTS RI WHERE RI.RDB$INDEX_NAME = RC.RDB$INDEX_NAME;
- The
REFERENTIAL_CONSTRAINTS
view:
CREATE VIEW REFERENTIAL_CONSTRAINTS ( CONSTRAINT_NAME, UNIQUE_CONSTRAINT_NAME, MATCH_OPTION, UPDATE_RULE, DELETE_RULE ) AS SELECT RDB$CONSTRAINT_NAME, RDB$CONST_NAME_UQ, RDB$MATCH_OPTION, RDB$UPDATE_RULE, RDB$DELETE_RULE FROM RDB$REF_CONSTRAINTS;
- The
TABLE_CONSTRAINTS
view:
CREATE VIEW TABLE_CONSTRAINTS ( CONSTRAINT_NAME, TABLE_NAME, CONSTRAINT_TYPE, IS_DEFERRABLE, INITIALLY_DEFERRED ) AS SELECT RDB$CONSTRAINT_NAME, RDB$RELATION_NAME, RDB$CONSTRAINT_TYPE, RDB$DEFERRABLE, RDB$INITIALLY_DEFERRED FROM RDB$RELATION_CONSTRAINTS;