Use the model area to visually join or manipulate the Tables, Views and Synonyms.
Show/Hide the Table Selector on the SQL Modeler Toolbar. It lists the tables, views and synonyms available to you for inclusion in your SQL Model. Double-click each desired Table, View, Synonym, OR drag and drop them from the list to the model area. As the objects are presented on the model area, join lines are drawn from any established foreign keys in the DDL.
Additionally, drag-and-drop objects from:
|
TIP:
|
Steps | Description | ||
---|---|---|---|
Clear an existing query from the Model Area, if required. | Click New Model on the SQL Modeler Toolbar. | ||
Define the type of statement you want to create. | Choose SELECT, UPDATE, DELETE, or INSERT from the SQL Modeler Toolbar. | ||
Add objects to the Model Area. |
Drag and drop Tables, Views, or Synonyms from the Table Selector to the modeling area. You can show/hide the Table Selector on the SQL Modeler Toolbar. | ||
Specify table columns to be used in the query. |
Select column names in the tables in the Model Area.
| ||
Set criteria for the query |
See the Criteria Tab. | ||
View your query as SQL code or as a data grid. |
Click the Generated Query Tab and Query Results Tab. | ||
Save the model |
Save the model from the SQL Modeler Toolbar. |
|
TIP: You can use the SQL Modeler Toolbar to copy the query to the Code Editor window. |
|
TIP: To specify criteria for a table join, double-click on the connecting line joining the two columns. This opens the View Joins Dialog. |
Menu | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Copy Model Image To Clipboard |
Copy a bitmap image of the model to the Windows Clipboard | ||||||||||
Tables |
| ||||||||||
Show |
| ||||||||||
SQL |
| ||||||||||
Auto Join All Objects | Join all tables based on DDL Foreign Key Constraints. | ||||||||||
Hide fields | Show / Hide the list of columns in the table in the model area. | ||||||||||
Zoom to table | Select a table to focus. | ||||||||||
Toggle Full Screen Mode | Show / Hide the Table Select List and Criteria/Generated Query/Query Results tabs. | ||||||||||
Optimize All Table Sizes | Minimize the size of the tables in the Model Area. | ||||||||||
Arrange Tables | Arrange the tables in the Model Area. |
Menu | Description | ||
---|---|---|---|
Set Table Alias | Set the Table Alias. The value is added to the Criteria Tab. | ||
Alias Field Names | Set the Field Alias for each column in the table. The values are added to the Criteria Tab. | ||
Auto Join | Automatically join this table to others based on DDL Foreign Key Constraints. | ||
Show Schema Name in SQL | Shows / Hide the schema name in the Generated Query (Generated Query Tab). | ||
Remove Table | Remove this table from the model. | ||
Select All | Select / unselect columns in the table. | ||
Unselect All | |||
Invert Selection | |||
Optimize Size | Restore the size of the table to its default size. | ||
Hide |
Temporarily hide the table from the model. While the table is hidden it will not be included in the Generated Query (Generated Query Tab).
|
Key | Action |
---|---|
Up and down arrow keys | Move you around in lists |
Space bar | Select / Unselect boxes |
Tab | Move forward one area (table, menu, list, etc) |
Shift-Tab | Move back one area (table, menu, list, etc) |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center