User's Guide

Adding an object to the query

Index  Previous  Next

To add an object to the query right click the query building area and select the Add Object item in the drop-down menu.

The Add New Object window allows you to add as many objects as you wish at once. The objects are grouped according to their type by three tabs: Tables, Views and Procedures (Functions). You may select one or several objects by holding the Ctrl key and then press the Add Object button to add these objects to the query. You may repeat this operation several times. After you finish adding objects, press the Close button to hide this window.

To remove an object from the query, select it and press the Del key or simply click the Close button in the object header.

For those servers that have schemas or allow selection of objects from different databases, you may filter objects by database or schema name by selecting the necessary schema or database from the combo box at the top of the window.

Active Query Builder can establish links between tables based on the information about foreign keys in the database. This ability is turned on by default. To turn it off, uncheck the Create links from foreign keys checkbox.

Index  Previous  Next