RDB$CHECK_CONSTRAINTS

Reserved Words and KeywordsMonitoring Tables

`RDB$CHECK_CONSTRAINTS`

RDB$CHECK_CONSTRAINTS provides the cross references between the names of system-generated triggers for constraints and the names of the associated constraints (NOT NULL constraints, CHECK constraints and the ON UPDATE and ON DELETE clauses in foreign key constraints).

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$CONSTRAINT_NAME`	`CHAR(63)`	Constraint name, defined by the user or automatically generated by the system
`RDB$TRIGGER_NAME`	`CHAR(63)`	For a `CHECK` constraint, it is the name of the trigger that enforces this constraint.For a `NOT NULL` constraint, it is the name of the table the constraint is applied to.For a foreign key constraint, it is the name of the trigger that enforces the `ON UPDATE`, `ON DELETE` clauses.

RDB$CONSTRAINT_NAME

CHAR(63)

Constraint name, defined by the user or automatically generated by the system

RDB$TRIGGER_NAME

CHAR(63)

For a CHECK constraint, it is the name of the trigger that enforces this constraint.For a NOT NULL constraint, it is the name of the table the constraint is applied to.For a foreign key constraint, it is the name of the trigger that enforces the ON UPDATE, ON DELETE clauses.

`RDB$USER_PRIVILEGES`

RDB$USER_PRIVILEGES stores the SQL access privileges for Firebird users and privileged objects.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$USER`	`CHAR(63)`	The user or object that is granted this privilege
`RDB$GRANTOR`	`CHAR(63)`	The user who grants the privilege
`RDB$PRIVILEGE`	`CHAR(6)`	The privilege granted hereby: `A` - all (all privileges) `S` - select (selecting data) `I` - insert (inserting rows) `D` - delete (deleting rows) `R` - references (foreign key) `U` - update (updating data) `X` - executing (procedure) `G` - usage (of other object types) `M` - role membership `C` - DDL privilege create `L` - DDL privilege alter `O` - DDL privilege drop
`RDB$GRANT_OPTION`	`SMALLINT`	Whether the WITH GRANT OPTION authority is included with the privilege: `0` - not included `1` - included
`RDB$RELATION_NAME`	`CHAR(63)`	The name of the object (table, view, procedure or role) the privilege is granted ON
`RDB$FIELD_NAME`	`CHAR(63)`	The name of the column the privilege is applicable to, for a column-level privilege (an `UPDATE` or `REFERENCES` privilege)
`RDB$USER_TYPE`	`SMALLINT`	Identifies the type of user the privilege is granted TO (a user, a procedure, a view, etc.)
`RDB$OBJECT_TYPE`	`SMALLINT`	Identifies the type of the object the privilege is granted ON `0` - table `1` - view `2` - trigger `5` - procedure `7` - exception `8` - user `9` - domain `11` - character set `13` - role `14` - generator (sequence) `15` - function `16` - BLOB filter `17` - collation `18` - package

RDB$USER

CHAR(63)

The user or object that is granted this privilege

RDB$GRANTOR

CHAR(63)

The user who grants the privilege

RDB$PRIVILEGE

CHAR(6)

The privilege granted hereby:

A - all (all privileges)
S - select (selecting data)
I - insert (inserting rows)
D - delete (deleting rows)
R - references (foreign key)
U - update (updating data)
X - executing (procedure)
G - usage (of other object types)
M - role membership
C - DDL privilege create
L - DDL privilege alter
O - DDL privilege drop

RDB$GRANT_OPTION

SMALLINT

Whether the WITH GRANT OPTION authority is included with the privilege:

0 - not included
1 - included

RDB$RELATION_NAME

CHAR(63)

The name of the object (table, view, procedure or role) the privilege is granted ON

RDB$FIELD_NAME

CHAR(63)

The name of the column the privilege is applicable to, for a column-level privilege (an UPDATE or REFERENCES privilege)

RDB$USER_TYPE

SMALLINT

Identifies the type of user the privilege is granted TO (a user, a procedure, a view, etc.)

RDB$OBJECT_TYPE

SMALLINT

Identifies the type of the object the privilege is granted ON

0 - table
1 - view
2 - trigger
5 - procedure
7 - exception
8 - user
9 - domain
11 - character set
13 - role
14 - generator (sequence)
15 - function
16 - BLOB filter
17 - collation
18 - package