Table or View Generator

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.

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.