Overview: When the output format is Database Output, tables are required to be defined (either when creating a new table or updating an existing one), in order for the SQL Query to know where to apply the changes. These tables must be defined using the Table dialog.
Accessing: There are multiple methods to access this dialog:
• | right clicking on a Schema and selecting the New Table option. |
• | right clicking on an already user defined table and selecting the Properties option. |
• | Command Type - the user can either insert new entries in the defined table, or update the existing ones |
• | PK - if checked, specifies is the column is the table's Primary Key |
• | Name - specifies the table's name |
• | Type - specifies if the data entered for this column is Text, Numeric or Date. |
• | Add - adds a new column to the existing ones |