Stores the SQL scripts that comprise packages.
Touchstone 2022 Database Reference
tPackageContent Table
Stores the SQL scripts that comprise packages.
| 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 | |
|---|---|---|---|---|---|---|---|
 | PackageContentID | Identifier for the record. | int | 4 | |||
| PackageSID | Unique system-generated sequential identifier for the package. For a complete list of records, see tPackage Table. | int | 4 | ||||
| DatasourceTypeCode | Code that represents the data source that the package applies to, for example, the AIRExposure database. For a complete list of codes, see tDataSourceType Table. | varchar | 10 | ||||
| Notes | AIR-specified notes about the content of the package. | nvarchar | 16 |  | |||
| Content | SQL that the system runs as part of the package. A package includes one or more SQL scripts. | nvarchar | 16 | ||||
| IsIgnorable | Indicates whether the package is in use.
| bit | 1 | ((0)) | |||
| RollbackScript | Definition of rolled back script. | nvarchar | 16 | |
| Name | Description | Expression |
|---|---|---|
| chk_tPackageContent_IgnoreXorRollback | ([IsIgnorable]=(0) OR [RollbackScript] IS NULL) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tPackage | Table | 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. | 1 |