Name |
Datatype |
Comment |
Is PK |
Is FK |
dyn_table_script_id |
bigint |
The automatically generated primary key of the dyn_table_script table. |
Yes |
No |
target_dbms_id |
bigint |
The unique identifier for an instance of Target DBMS. This identifier must be
kept in sync with programming code that uses an enumeration or fixed constant to
identify particular values.
|
No |
Yes |
dyn_table_script_name |
varchar(255) |
The name of the Dynamic Table Script. |
No |
No |
script_type_id |
bigint |
A Foreign Key to the Dynamic Table Script Type table. |
No |
Yes |
sql_script |
varchar(max) |
The value of a Dynamic Table Script, stored as a long text object. |
No |
No |
is_active |
bit |
Indicates if the script is the active version, or if it is a superceded
version. When deployment loads the script, the SQL text of the script is
compared with any existing active row. If it is equal, the script is not
loaded. If unequal, the existing script is marked inactive, and a new active
script is loaded.
|
No |
No |
script_sort_order |
int |
A sort number used to order a list of Dynamic Table Script. |
No |
No |
defn_subtype_id |
int |
A Foreign Key to the Definition Subtype table. |
No |
Yes |
run_as_proxy |
bit |
Used for Oracle, indicating if a proxy connection to impersonate the schema
account is needed.
|
No |
No |