## Add Table/View/Query dialog

This dialog appears when you do either of the following:

- In the Query Editor, click the Add Table/View/Query button on the toolbar or select Add Table/View/Query from the Query menu.
- In the Catalog Browser, right-click the Business View node and select Add Business View from the shortcut menu. Then in the Input Business View Name dialog provide a name and click OK.

It helps you to add resources to use in a query or a business view. See the dialog.

All Tables/Views/Queries

List all the tables, views, synonyms, queries, imported SQLs, stored procedures, and user defined data sources in the current catalog data source that can be added to the query or business view.

When two resources (for example, a table and a view) use the same name, they cannot be added at the same time, and when a table is already contained in a query, you cannot add the table and the query at the same time.

Selected Tables/Views/Queries

Lists all the added tables, views, synonyms, queries, imported SQLs, stored procedures, and user defined data sources.

Adds the selected resources from the left box to the right box. If the selected resources contain a table, view or synonym that is already added, the Input Table Name dialog is displayed for you to specify another name for the resource.

Removes the selected resources from the right box.

Include Added Tables/Views

Specifies whether to list the tables, views and synonyms in JDBC connections in the All Tables/Views/Queries box that have already been added to the right box. This option is available only when there is at least a JDBC connection in the current catalog data source.

OK

Adds the selected resources to the current query or business view. When a query, imported SQL, stored procedure or user defined data source is added, it will be added as a single table with all of its columns.

If the query or business view does not contain only tables/views from one JDBC connection, the computed column, customized SQL, and preview features cannot work anymore.

Cancel

Exits the dialog and discards the setting.

Help

Displays the help document of this feature.

###### Related topics:

- Adding and deleting tables in a query