MSarticles (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSarticles (Transact-SQL)

 

Applies To: SQL Server

The MSarticles table contains one row for each article being replicated by a Publisher. This table is stored in the distribution database.

Column nameData typeDescription
publisher_idsmallintThe ID of the Publisher.
publisher_dbsysnameThe name of the Publisher database.
publication_idintThe ID of the publication.
articlesysnameThe name of the article.
article_idintThe ID of the article.
destination_objectsysnameThe name of the table created at the Subscriber.
source_ownersysnameThe name of the schema of the source table at the Publisher.
source_objectsysnameThe name of the source object from which to add the article.
descriptionnvarchar(255)The description of the article.
destination_ownersysnameThe name of the schema of the table created at the Subscriber.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft