RDB$PUBLICATIONS

`RDB$PUBLICATIONS`

RDB$PUBLICATIONS stores the replication publications defined in the database.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$PUBLICATION_NAME`	`CHAR(63)`	Publication name
`RDB$OWNER_NAME`	`CHAR(63)`	The username of the user who created the publication
`RDB$SYSTEM_FLAG`	`SMALLINT`	Flag: `0` - user-defined `1` or higher - system-defined
`RDB$ACTIVE_FLAG`	`SMALLINT`	Inactive (`0`) or active (`1`)
`RDB$AUTO_ENABLE`	`SMALLINT`	Automatically add new tables to publication: `0` - disabled `1` - enabled (tables are automatically added to this publication)

RDB$PUBLICATION_NAME

CHAR(63)

Publication name

RDB$OWNER_NAME

CHAR(63)

The username of the user who created the publication

RDB$SYSTEM_FLAG

SMALLINT

Flag:

0 - user-defined
1 or higher - system-defined

RDB$ACTIVE_FLAG

SMALLINT

Inactive (0) or active (1)

RDB$AUTO_ENABLE

SMALLINT

Automatically add new tables to publication:

0 - disabled
1 - enabled (tables are automatically added to this publication)

Note	In Firebird 5.0 there is a single (pre-defined) publication named `RDB$DEFAULT`.User-defined publications will be available in future Firebird releases.

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