MSreplication_objects (Transact-SQL)


Applies To: SQL Server

The MSreplication_objects table contains one row for each object that is associated with replication in the Subscriber database. This table is stored in the subscription database.

Column nameData typeDescription
publishersysnameThe name of the Publisher.
publisher_dbsysnameThe name of the Publisher database.
publicationsysnameThe name of the publication.
object_namesysnameThe name of the object.
object_typechar(2)The object type:

 u = Table.

 t = Trigger.

 p = Stored Procedure.
articlesysnameThe name of the article with which the object is associated.

Replication Tables (Transact-SQL)

Community Additions