Transact-SQL Reference
MSarticles
The MSarticles table contains one row for each article being replicated by a Publisher. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
| publisher_id | smallint | ID of the Publisher. |
| publisher_db | sysname | Name of the Publisher database. |
| publication_id | int | ID of the publication. |
| article | sysname | Name of the article. |
| article_id | int | ID of the article. |
| destination_object | sysname | Name of the table created at the Subscriber. |
| source_owner | sysname | Name of the owner of the source table at the Publisher. |
| source_object | sysname | Name of the source object from which to add the article. |
| description | nvarchar(255) | Description of the article. |