Contains a row for each of the publications posted by the publishing server.
Column | Datatype | Description |
---|---|---|
description | varchar(255) | Descriptive entry for the publication. |
name | varchar(30) | Unique name associated with the publication. |
pubid | int | An identity column providing a unique ID number for the publication. |
repl_freq | tinyint | 0 indicates transaction based; 1 indicates scheduled table refresh. |
restricted | bit | Sets the security option for the publication. 1 indicates restricted; 0 indicates unrestricted. 0 is the default. |
status | tinyint | 0 indicates log-based; 1 indicates not log-based; default is log-based, 0 is the default. |
sync_method | tinyint | 0 indicates native bcp; 1 indicates char bcp. |
taskid | int | Scheduled task ID. |
unc1syspublications nonclustered, unique on pubid
unc2syspublications nonclustered, unique on name
sp_addarticle | sp_changesubstatus | sp_helparticle |
sp_addpublication | sp_dboption | sp_helparticlecolumns |
sp_addsubscription | sp_droparticle | sp_helppublication |
sp_articlecolumn | sp_droppublication | sp_helpsubscription |
sp_changearticle | sp_dropsubscription | sp_subscribe |
sp_changepublication | sp_enumfullsubscribers | sp_unsubscribe |
sp_changesubscription |