RDB$PUBLICATION

Reserved Words and KeywordsMonitoring Tables

`RDB$PUBLICATION_TABLES`

RDB$PUBLICATION_TABLES stores the names of tables that are replicated as part of a publication.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$PUBLICATION_NAME`	`CHAR(63)`	Publication name
`RDB$TABLE_NAME`	`CHAR(63)`	Table name

RDB$PUBLICATION_NAME

CHAR(63)

Publication name

RDB$TABLE_NAME

CHAR(63)

Table name

`RDB$REF_CONSTRAINTS`

RDB$REF_CONSTRAINTS stores the attributes of the referential constraints — Foreign Key relationships and referential actions.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$CONSTRAINT_NAME`	`CHAR(63)`	Foreign key constraint name, defined by the user or automatically generated by the system
`RDB$CONST_NAME_UQ`	`CHAR(63)`	The name of the primary or unique key constraint linked by the `REFERENCES` clause in the constraint definition
`RDB$MATCH_OPTION`	`CHAR(7)`	Not used.The current value is `FULL` in all cases
`RDB$UPDATE_RULE`	`CHAR(11)`	Referential integrity actions applied to the foreign key record(s) when the primary (unique) key of the parent table is updated: `RESTRICT`, `NO ACTION`, `CASCADE`, `SET NULL`, `SET DEFAULT`
`RDB$DELETE_RULE`	`CHAR(11)`	Referential integrity actions applied to the foreign key record(s) when the primary (unique) key of the parent table is deleted: `RESTRICT`, `NO ACTION`, `CASCADE`, `SET NULL`, `SET DEFAULT`

RDB$CONSTRAINT_NAME

CHAR(63)

Foreign key constraint name, defined by the user or automatically generated by the system

RDB$CONST_NAME_UQ

CHAR(63)

The name of the primary or unique key constraint linked by the REFERENCES clause in the constraint definition

RDB$MATCH_OPTION

CHAR(7)

Not used.The current value is FULL in all cases

RDB$UPDATE_RULE

CHAR(11)

Referential integrity actions applied to the foreign key record(s) when the primary (unique) key of the parent table is updated: RESTRICT, NO ACTION, CASCADE, SET NULL, SET DEFAULT

RDB$DELETE_RULE

CHAR(11)

Referential integrity actions applied to the foreign key record(s) when the primary (unique) key of the parent table is deleted: RESTRICT, NO ACTION, CASCADE, SET NULL, SET DEFAULT