---
title: "sysmergeschemachange (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "03/14/2017"
ms.prod: sql
ms.prod_service: "database-engine"
ms.reviewer: ""
ms.technology: replication
ms.topic: "language-reference"
f1_keywords: 
  - "sysmergeschemachange_TSQL"
  - "sysmergeschemachange"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "sysmergeschemachange system table"
ms.assetid: ae9ce16e-6ee9-4c7c-8210-a9bf2c7efdf0
author: stevestein
ms.author: sstein
---
# sysmergeschemachange (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  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**|The ID of the publication.|  
|**artid**|**uniqueidentifier**|The ID of the article.|  
|**schemaversion**|**int**|The number of the last schema change.|  
|**schemaguid**|**uniqueidentifier**|The unique ID of the last schema.|  
|**schematype**|**int**|The type of schema change:<br /><br /> **-1** = Not valid.<br /><br /> **1** = SQL command.<br /><br /> **2** = Schema script.<br /><br /> **3** = Native bulk-copy program utility (BCP).<br /><br /> **4** = Character BCP.<br /><br /> **5** = Last recorded generation.<br /><br /> **6** = Last sent generation.<br /><br /> **7** = Directory.<br /><br /> **8** = Priority.<br /><br /> **9** = Retention period.<br /><br /> **10** = Trigger script.<br /><br /> **11** = Alter table.<br /><br /> **12** = Reinitialize all.<br /><br /> **13** = ALTER TABLE (non-[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]).<br /><br /> **14** = Reinitialize with upload.<br /><br /> **15** = Constraint and index script.<br /><br /> **16** = Metadata cleanup.<br /><br /> **17** = Update last sent generation.<br /><br /> **18** = Backward compatibility level.<br /><br /> **19** = Validate Subscriber information.<br /><br /> **20** = Well partitioned.<br /><br /> **21** = Custom resolver.<br /><br /> **22** = Article processing order.<br /><br /> **23** = Published in transactional publication.<br /><br /> **24** = Compensate for errors.<br /><br /> **25** = Alternate snapshot folder.<br /><br /> **26** = Download-only.<br /><br /> **27** = Delete tracking.<br /><br /> **40** = Pre-creation snapshot script.<br /><br /> **45** = Post-creation snapshot script.<br /><br /> **46** = On-demand user script.<br /><br /> **50** = Snapshot header begin.<br /><br /> **51** = Snapshot header end.<br /><br /> **52** = Snapshot trailer.<br /><br /> **53** = File Transfer Protocol (FTP) address.<br /><br /> **54** = FTP port.<br /><br /> **55** = FTP subdirectory.<br /><br /> **56** = Snapshot compressed.<br /><br /> **57** = FTP login.<br /><br /> **58** = FTP password.<br /><br /> **60** = System pre-creation script.<br /><br /> **61** = Stored procedure schema.<br /><br /> **62** = View schema.<br /><br /> **63** = User-defined function schema.<br /><br /> **64** = View indexes.<br /><br /> **65** = Extended properties.<br /><br /> **66** = Validate.<br /><br /> **67** = Pre-snapshot SQL command.<br /><br /> **71** = Dynamic snapshot validation.<br /><br /> **80** = System table native BCP 9.0.<br /><br /> **81** = System table character BCP 9.0.<br /><br /> **82** = System table native BCP 9.0 (global-only).<br /><br /> **83** = System table character BCP 9.0 (global-only).<br /><br /> **84** = System table native BCP 9.0 (lightweight).<br /><br /> **85** = System table character BCP 9.0 (lightweight).<br /><br /> **128** = Dynamic BCP (bit).<br /><br /> **131** = Dynamic native BCP.<br /><br /> **132** = Dynamic character BCP.<br /><br /> **208** = Dynamic system table native BCP 9.0.<br /><br /> **209** = Dynamic system table character BCP 9.0.<br /><br /> **210** = Dynamic system table native BCP 9.0 (global-only).<br /><br /> **211** = Dynamic system table character BCP 9.0 (global-only).<br /><br /> **212** = Dynamic system table native BCP 9.0 (lightweight).<br /><br /> **213** = Dynamic system table character BCP 9.0 (lightweight).<br /><br /> **300** = Data Definition Language (DDL) actions.<br /><br /> **1024** = Incremental snapshot control.<br /><br /> **1049** = Incremental snapshot folder.<br /><br /> **1074** = Incremental snapshot begin header.<br /><br /> **1075** = Incremental snapshot end header.<br /><br /> **1076** = Incremental snapshot trailer.<br /><br /> **1077** = Incremental FTP address.<br /><br /> **1078** = Incremental FTP port.<br /><br /> **1079** = Incremental FTP subdirectory.<br /><br /> **1080** = Incremental compressed snapshot.<br /><br /> **1081** = Incremental FTP login.<br /><br /> **1082** = Incremental FTP password.|  
|**schematext**|**nvarchar(2000)**|The name of the script file, or a command which includes a file name|  
|**schemastatus**|**tinyint**|Indicates whether a schema change is pending for the article, which can be one of the following values:<br /><br /> **0** = Inactive.<br /><br /> **1** = Active.<br /><br /> When a schema change is pending, this value is set to **1**.|  
|**schemasubtype**|**int**|The subtype of schema change:<br /><br /> **1** = ADDCOLUMN<br /><br /> **2** = DROPCOLUMN<br /><br /> **3** = ALTERCOLUMN<br /><br /> **4** = ADDPRIMARYKEY<br /><br /> **5** = ADDUNIQUE<br /><br /> **6** = ADDREFERENCE<br /><br /> **7** = DROPCONSTRAINT<br /><br /> **8** = ADDDEFAULT<br /><br /> **9** = ADDCHECK<br /><br /> **10** = DISABLETRIGGER<br /><br /> **11** = ENABLETRIGGER<br /><br /> **12** = DISABLETRIGGER<br /><br /> **13** = ENABLETRIGGER<br /><br /> **14** = ENABLECONSTRAINT<br /><br /> **15** = DISABLECONSTRAINT<br /><br /> **16** = ENABLECONSTRAINT<br /><br /> **17** = DISABLECONSTRAINT|  
  
## See Also  
 [Replication Tables &#40;Transact-SQL&#41;](../../relational-databases/system-tables/replication-tables-transact-sql.md)   
 [Replication Views &#40;Transact-SQL&#41;](../../relational-databases/system-views/replication-views-transact-sql.md)