Contains one row for each publication that is replicated by a Publisher. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
| publisher_id | smallint | ID of the Publisher. |
| publisher_db | sysname | Name of the Publisher database. |
| publication | sysname | Name of the publication. |
| publication_id | int identity | ID of the publication. |
| publication_type | int | Type of publication: 0 = Snapshot 1 = Transactional |
| thirdparty_flag | bit | Indicates whether a publication is a Microsoft® SQL Server™ database: 0 = SQL Server 1 = Data source other than SQL Server |
| independent_agent | bit | Indicates whether there is a stand-alone Distribution Agent for this publication. |
| immediate_sync | bit | Indicates whether synchronization files are created or re-created each time the Snapshot Agent runs. |
| allow_push | bit | Indicates whether push subscriptions can be created for the given publication. |
| allow_pull | bit | Indicates whether pull subscriptions can be created for the given publication. |
| allow_anonymous | bit | Indicates whether anonymous subscriptions can be created for the given publication. |
| description | nvarchar(255) | Description of the publication. |
| vendor_name | nvarchar(100) | Name of the vendor (if Publisher is not a SQL Server database). |
| retention | int | Retention period of the publication. |