Add a Table

That command allows adding a table manually to avoid searching it in a long list.

Source Alias represents the current data source.

Table Name allows entering the full path and table name to be added.

Validate using the <Add> button.

That command can be used when creating a new query or modifying an existing query. In that last case, you will need to add at least one join condition.

Example for full path name according to the data source:

iSeries – AS/400: Library/Table or Library /Table(Member)

SQL Server: master.dbo.table or ClicknDECiDEDemo.dbo.customer

Oracle: scott.dept

Etc.