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