Publication databases use the following tables for replication purposes:
| Table | Description |
|---|---|
| sysarticles | Has a row for each of the articles posted by the publication server. |
| sysobjects | Has a category field set by replication for each object marked for replication. This is set when an article is created and when an article is initially subscribed to. |
| syspublications | Has a row for each of the publications posted by the publication server. |
| syssubscriptions | Associates the IDs of published articles with the IDs of all subscription servers expecting to receive the data. |
For more information about these tables, see the Microsoft SQL Server Transact-SQL Reference.