Stores information about any packages applied to the database.
Touchstone 2022 Database Reference
tDbHistory Table
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 1 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DbHistoryID | Identifier for the change record. | int | 4 | |||
| HistoryType | Type of the change applied to the database, for example, CREATE or UPGRADE. | varchar | 50 |  | |||
| ServerName | Name of the SQL Server associated with the database. | sysname | 128 | (coalesce(CONVERT([sysname],serverproperty('ServerName')),@@servername)) | |||
| DbName | Name of the database. | sysname | 128 | (db_name()) | |||
| SQLVersion | Version of SQL Server associated with the database change. | varchar | 50 | (CONVERT([varchar](50),serverproperty('ProductVersion'))) | |||
| SystemVersion | Version of the product associated with the database change. | varchar | 10 | | |||
| SystemCodeVersion | Version of the product code associated with the database change. | varchar | 10 | | |||
| StartVersion | Version of the database prior to the application of the package. | varchar | 10 | | |||
| EndVersion | Version of the database after the application of the package. | varchar | 10 | | |||
| StartCodeVersion | Version of the product code associated with the database prior to the application of the package. | varchar | 10 | | |||
| EndCodeVersion | Version of the product code associated with the database after the application of the package. | varchar | 10 | | |||
| PackageSID | Unique system-generated sequential identifier for the package. For a complete list of records, see tPackage Table. | int | 4 | | |||
| PackageType | Type of the package, for example, CREATE or UPGRADE. | varchar | 10 | | |||
| PackageName | Name of the package. | varchar | 50 | | |||
| PackageDescription | Description of the package. | nvarchar | 16 | | |||
| ContentID | Identifier for the contents of the package. For a complete list of records, see tPackageContent Table. | int | 4 | | |||
| ContentNotes | Detailed information about the contents of the package. | nvarchar | 16 | | |||
| DateApplied | Date and time when the package was applied. | datetime2 | 4 | (sysdatetime()) | |||
| IsIgnorable | bit | 1 | ((0)) | ||||
| IsRolledBack | bit | 1 | ((0)) | ||||
| RollbackScript | nvarchar | 16 | |