MSpublications (Transact-SQL)
Applies to: 
SQL Server
The MSpublications table 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 | The ID of the Publisher. |
publisher_db |
sysname | The name of the Publisher database. |
publication |
sysname | The name of the publication. |
publication_id |
int | The ID of the publication. |
publication_type |
int | The type of publication:0 = Transactional1 = Snapshot2 = Merge |
thirdparty_flag |
bit | Indicates whether a publication is a Microsoft SQL Server database:0 = SQL Server1 = Data source other than SQL Server |
independent_agent |
bit | Indicates whether there's 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) | The description of the publication. |
vendor_name |
nvarchar(100) | The name of the vendor if Publisher isn't a SQL Server database. |
retention |
int | The retention period of the publication, in hours. |
sync_method |
int | The synchronization method:0 = Native (produces native-mode bulk copy output of all tables)1 = Character (produces a character-mode bulk copy output of all tables)3 = Concurrent (produces native-mode bulk copy output of all tables but doesn't lock the table during the snapshot)4 = Concurrent_c (produces a character-mode bulk copy output of all tables but doesn't lock the table during the snapshot)The values 3 and 4 are available for transactional replication and merge replication, but not for snapshot replication. |
allow_subscription_copy |
bit | Enables or disables the ability to copy the subscription databases that subscribe to this publication.0 - copying is disabled1 - copying is enabled |
thirdparty_options |
int | Specifies whether the display of a publication in the Replication folder in SQL Server Management Studio is suppressed:0 = Display a heterogeneous publication in the Replication folder in SQL Server Management Studio.1 = Suppress the display a heterogeneous publication in the Replication folder in SQL Server Management Studio. |
allow_queued_tran |
bit | Specifies whether publication allows queued updating:0 = Publication is non-queued1 = Publication is queued |
options |
int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
retention_period_unit |
tinyint | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
allow_initialize_from_backup |
bit | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
min_autonosync_lsn |
varbinary(16) | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |