The Table or View Generator retrieves column data of a compatible type from a table or view. Please note, that the Generator retrieves the data that resided in the table before data population.
The dialog box of the Table or View Generator contains basic settings and custom settings. You can customize the generator by changing the basic and custom settings.
Connection
Specify a server connection.
Database
Select a database you want to retrieve data from.
Table
Select the table you want to retrieve data from. When the Table option is selected, the View option is disabled.
View
Select the view you want to retrieve data from. When the View option is selected, the Table option is disabled.
WHERE filter
To filter data being retrieved from a column, type an SQL expression and click Validate.
Column
Select the column you want to retrieve data from.
Note
If you need to insert the data that are to be generated, then you need to use the Foreign Key (manually assigned) Generator.