sysmergeschemachange (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)