Adding and Removing Objects in Queries
To add an object to the query:
1. Right click the Query Building Area and click Add Object.
The Add New Object window opens:
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 four tabs: Tables, Views, Procedures (functions), and Synonyms. To select multiple objects, hold the Ctrl key down, click the names of the objects you want to add to the query, and then click Add Object. You may repeat this multiple times. After you finish adding objects, click Close to hide this window.
Note:
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, clear Create links from foreign keys.
2. If your server has schemas, or allows selection of objects from different databases, you can filter objects by database or schema name. To do so, select the necessary schema or database from Filter objects by Schema name drop-down menu.
3. To remove an object from the query, select it and press the Delete key on your keyboard. You can also click Close in the object header.