Contains one row for each publication defined in the database. This table is stored in the published database.
| Column name | Data type | Description |
|---|---|---|
| description | nvarchar(255) | Descriptive entry for the publication. |
| name | sysname | Unique name associated with the publication. |
| pubid | int | Identity column providing a unique ID for the publication. |
| repl_freq | tinyint | Replication frequency: 0 = Transaction based 1 = Scheduled table refresh |
| status | tinyint | Status: 0 = Inactive 1 = Active |
| sync_method | tinyint | Synchronization method: 0 = Native bulk copy program (bcp utility) 1 = Character bulk copy |
| snapshot_jobid | binary(16) | Scheduled task ID. |
| independent_agent | bit | Publication attribute. |
| immediate_sync | bit | Indicates whether the synchronization files are created or re-created each time the Snapshot Agent runs. |
| enabled_for_internet | bit | Indicates whether the synchronization files for the publication are exposed to the Internet through FTP and other services. |
| allow_push | bit | Indicates whether push subscriptions are allowed on the publication. |
| allow_pull | bit | Indicates whether pull subscriptions are allowed on the publication. |
| allow_anonymous | bit | Indicates whether anonymous subscriptions are allowed on the publication. |
| immediate_sync_ready | bit | Indicates whether the Snapshot Agent is completed one time for the immediate update publication. It has no definition for a non- immediate update publication. |
| allow_sync_tran | bit | Publication attribute. |
| autogen_sync_procs | bit | Publication attribute. |
| retention | int | Retention period, in days. |