Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
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)