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 |
| schematext | nvarchar(255) | Name of the script file, or a command which includes a file name |