Stores information about the scripts that Touchstone uses to create databases dynamically.
The content of the script is available in tScriptContent Table.
Touchstone 2022 Database Reference
tScript Table
Stores information about the scripts that Touchstone uses to create databases dynamically.
The content of the script is available in tScriptContent Table.
| Creation Date | 12/8/2011 10:47 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 45 |
| Data Space Used | 8.00 KB |
| Index Space Used | 88.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ScriptSID | Unique system-generated sequential identifier for the script record. | int | 4 | |||
| ScriptTypeCode | Code that represents the script file type. For a complete list of codes, see tScriptType Table. | varchar | 10 | ||||
| DataSourceTypeCode | Code that represents the data source type. For a complete list of codes, see tDataSourceType Table. | varchar | 10 | ||||
| Name | Name of the script. | varchar | 255 | ||||
| Version | Version of the script. | varchar | 10 | ||||
| CodeVersion | Version number for the code. | varchar | 10 | ||||
| ReleasedDate | Date and time when the script will be released for use. | datetime | 4 | ||||
| ParentScriptSID | Unique system-generated sequential identifier for the parent script record. For a complete list of records, see the ScriptSID column. | int | 4 |  | |||
| SeqNum | Order number of the script. For example, a value of 2 indicates that the script is the second script to be executed in the script order. | smallint | 2 | ||||
| Description | Description of the script. | varchar | 4000 | | |||
| IsActive | Indicates whether the script is in use.
| bit | 1 | ((1)) | |||
| EnteredDate | Date and time when the script was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the script was last modified. | datetime | 4 | (getutcdate()) | |||
| ExistingVersion | Reserved for future use. | varchar | 10 | | |||
| ExistingCodeVersion | Reserved for future use. | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tScriptContent | Table | Stores the content of the scripts that Touchstone uses to create databases dynamically. More information about the scripts is available in tScript Table. | 1 |