sysmergeschemachange (Transact-SQL)
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: -1 = Not valid. 1 = SQL command. 2 = Schema script. 3 = Native bulk-copy program utility (BCP). 4 = Character BCP. 5 = Last recorded generation. 6 = Last sent generation. 7 = Directory. 8 = Priority. 9 = Retention period. 10 = Trigger script. 11 = Alter table. 12 = Reinitialize all. 13 = ALTER TABLE (non-SQL Server). 14 = Reinitialize with upload. 15 = Constraint and index script. 16 = Metadata cleanup. 17 = Update last sent generation. 18 = Backward compatibility level. 19 = Validate Subscriber information. 20 = Well partitioned. 21 = Custom resolver. 22 = Article processing order. 23 = Published in transactional publication. 24 = Compensate for errors. 25 = Alternate snapshot folder. 26 = Download-only. 27 = Delete tracking. 40 = Pre-creation snapshot script. 45 = Post-creation snapshot script. 46 = On-demand user script. 50 = Snapshot header begin. 51 = Snapshot header end. 52 = Snapshot trailer. 53 = File Transfer Protocol (FTP) address. 54 = FTP port. 55 = FTP subdirectory. 56 = Snapshot compressed. 57 = FTP login. 58 = FTP password. 60 = System pre-creation script. 61 = Stored procedure schema. 62 = View schema. 63 = User-defined function schema. 64 = View indexes. 65 = Extended properties. 66 = Validate. 67 = Pre-snapshot SQL command. 71 = Dynamic snapshot validation. 80 = System table native BCP 9.0. 81 = System table character BCP 9.0. 82 = System table native BCP 9.0 (global-only). 83 = System table character BCP 9.0 (global-only). 84 = System table native BCP 9.0 (lightweight). 85 = System table character BCP 9.0 (lightweight). 128 = Dynamic BCP (bit). 131 = Dynamic native BCP. 132 = Dynamic character BCP. 208 = Dynamic system table native BCP 9.0. 209 = Dynamic system table character BCP 9.0. 210 = Dynamic system table native BCP 9.0 (global-only). 211 = Dynamic system table character BCP 9.0 (global-only). 212 = Dynamic system table native BCP 9.0 (lightweight). 213 = Dynamic system table character BCP 9.0 (lightweight). 300 = Data Definition Language (DDL) actions. 1024 = Incremental snapshot control. 1049 = Incremental snapshot folder. 1074 = Incremental snapshot begin header. 1075 = Incremental snapshot end header. 1076 = Incremental snapshot trailer. 1077 = Incremental FTP address. 1078 = Incremental FTP port. 1079 = Incremental FTP subdirectory. 1080 = Incremental compressed snapshot. 1081 = Incremental FTP login. 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: 0 = Inactive. 1 = Active. When a schema change is pending, this value is set to 1. |
schemasubtype |
int |
The subtype of schema change: 1 = ADDCOLUMN 2 = DROPCOLUMN 3 = ALTERCOLUMN 4 = ADDPRIMARYKEY 5 = ADDUNIQUE 6 = ADDREFERENCE 7 = DROPCONSTRAINT 8 = ADDDEFAULT 9 = ADDCHECK 10 = DISABLETRIGGER 11 = ENABLETRIGGER 12 = DISABLETRIGGER 13 = ENABLETRIGGER 14 = ENABLECONSTRAINT 15 = DISABLECONSTRAINT 16 = ENABLECONSTRAINT 17 = DISABLECONSTRAINT |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables