The DDTable table contains one entry for each table created by Script Manager executions. This is a public table. Holds info about DBMS table objects.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| ddtableid | integer | not null | Unique over all DD tables. NOTE: next ID kept in LookOutIdControl. |
| requestid | integer | with null | The ID from the Request table for the request that created the this table. |
| executionid | integer | with null | The ID from the Execution table for the execution which created this table. |
| dduserid | integer | not null | The ID from the User table for the user owning the request.
|
| ddproviderid | integer | not null | The ID from the Provider table for the profile through which this table was created. |
| dddatabasename | varchar(128) | with null | The name of the Database (if any) in which this table was created. |
| ddtablename | varchar(128) | not null | The name of the table that was created. |
| ddtablenote | varchar(255) | with null | The optional user-defined note. |
| ddtablecreatetime | date | not null | The Datetime at which table was created. |
Product Name: Data Transformer
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| ddtableid | ddcolumn | ddtableid |