sysmergeschemachange (T-SQL)

Contains information about the published articles generated by the Snapshot Agent. This table is stored in the published database.

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.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.