Archive SchemaVersion table
- Last UpdatedApr 24, 2025
- 1 minute read
The schemaVersion table keeps information about the schema versions for the Historical tables. This information is used during the archive/dearchive process.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
dbName |
sysnameType |
The name of the database. |
|
tableName |
sysnameType |
The name of the table belonging to the dbName database. |
|
schemaVer |
IDType |
The schema version number. |
|
active |
boolean |
The value of this field is 1 when the record defines the schema for the current version. If the record does not define the schema for the current version, the value of this field is 0. |
|
xmlFileName |
The name of the file that contains the schema data for the schema version defined in the record. |
|
|
xmlData |
varBinary(MAX) |
The schema data for this schema version. |