Stores information about the packages applied to the environment.
During system events such as register or upgrade events, the system uses the information in the table to determine whether a package applies to a target database.
| Creation Date | 4/29/2019 11:20 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | PackageSID | Unique system-generated sequential identifier for the package. | int | 4 | |||
| PackageType | Type of the package, for example, CREATE or UPGRADE. | varchar | 10 | ||||
| AppliesToVersion | Version of the product that the package is compatible with. | varchar | 10 |  | |||
| Name | Name of the package. | nvarchar | 50 | | |||
| Description | Description of the package. | nvarchar | 16 | ||||
| ReleasedDate | Date and time that the package was made available. | datetime2 | 4 | | |||
| InstallDate | Date and time that the package was installed. | datetime2 | 4 | (sysdatetime()) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tPackageContent | Table | Stores the SQL scripts that comprise packages. | 1 |