Contains one row for each merge publication defined in the database. This table is stored in the published database.
| Column name | Data type | Description |
|---|---|---|
| publisher | sysname | Name of the default server. |
| publisher_db | sysname | Name of the default Publisher database. |
| name | sysname | Name of the publication. |
| description | nvarchar(255) | Brief description of the publication. |
| retention | int | Retention period, expressed in days, for the entire publication set. |
| publication_type | tinyint | Indicates the publication is filtered: 0 = Not filtered 1 = Filtered |
| pubid | uniqueidentifier | Unique identification number for this publication; generated when the publication is added. |
| designmasterid | uniqueidentifier | Reserved for future use. |
| parentid | uniqueidentifier | Indicates the parent publication from which the current peer or subset publication was created (used for hierarchical publishing topologies). |
| sync_mode | tinyint | Synchronization mode of this publication: 0 = Native 1 = Character |
| allow_push | int | Indicates whether the publication allows push subscriptions. |
| allow_pull | int | Indicates whether the publication allows pull subscriptions. |
| allow_anonymous | int | Indicates whether the publication allows anonymous subscriptions. |
| centralized_conflicts | int | Indicates whether the conflict records are stored at the Publisher. |
| status | tinyint | Reserved for future use. |
| snapshot_ready | tinyint | Indicates the snapshot of the publication is ready: 0 = Snapshot is ready for use. 1 = Snapshot is not ready for use. |
| enabled_for_internet | bit | Indicates whether the synchronization files for the publication are exposed to the Internet, through FTP and other services. |
| dynamic_filters | bit | Indicates whether the publication is filtered on a dynamic property. |