sysmergeschemachange (Transact-SQL)

pubid

uniqueidentifier

The ID of the publication.

schemaversion

int

The number of the last schema change.

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.

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.