Page History
...
| Info |
|---|
You can add additional databases (depending on the the server vendor) from a single connected server by clicking the triangle in the Database Pane header and selecting [Add Database]. You cannot add databases from different registered servers in the same Data Pane. You can, however, add multiple databases from the same connection when the server supports cross-database queries. See Multi-Database Query for more. |
Primary
The databases will appear in the Database Pane of the Data Pane. If you do not choose a database when launching the Query Builder, whatever database is the default database for your registered server appears as [Primary] by default, which is indicated with a check mark. If you launch the Query Builder by right clicking directly on a database, that database will appear as Primary.
...
The database you chose now displays the check mark to indicate it is now used as the Primary.
See Multi-Database Query for how to write queries that use data from two different databases.
Note that any tables, views or columns from the database you remove will be marked as invalid in the decks and Diagram Pane. See the Invalid Objects, Logic Filters or Joins section for more.
Data Pane Menu
...
- Add Database... - Allows adding an additional database from the same server connection you are using. See Adding Multiple Databases to the Data Pane for more.
- Group By Schema - Enables/disables grouping tables in the Table Pane by Schema (for those databases which support it). See Grouping Tables by Schema below for more.
- Show System Tables and Views - Hides/Shows System Tables in the Table Pane.
- Reconnect - Reconnects the current connection. See Reconnecting for more details.
- Refresh - Refreshes the contents of the Data Pane by retrieving the tables and views from the currently connected server. See Refresh the Query Builder for more details.
- Close - Closes the current connection, disconnects from the current server and clears all Panes of content. You will receive a confirmation dialog that warns you closing clears the Query Builder Window of all content.
- Edit Connection... - Edit the Server Registration properties for the current connection
- Properties - Displays connection properties for the current server.
...
Your Tables and View Panes will pull in the latest schema objects from your Data Source. Red lines and red background colors indicate which items you have in the Diagram Pane and other decks that are no longer valid, informing you that you should take action to correct them. The most likely cause for an invalid server object or join is that a table, column or view was dropped from the server.
See Invalid Objects, Filter Logic or Joins for more information.