sysmergeschemachange

Transact-SQL Reference

Transact-SQL Reference

sysmergeschemachange

Contains information about the published articles generated by the Snapshot Agent. This table is stored in the publication and subscription databases.

Column name Data type Description
pubid uniqueidentifier ID of the publication
artid uniqueidentifier ID of the article
schemaversion int Number of the last schema change
schemaguid uniqueidentifier Unique ID of the last schema
schematype int Type of schema:

1 = Schema
2 = System schema
3 = Trigger script

schematext nvarchar(255) Name of the script file, or a command which includes a file name