Model Area
Use the model area to visually join or manipulate the Tables, Views and Synonyms.
Add objects
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:
- DB Navigator tree (single object only)
- DB Navigator details pane (when a list is displayed)
- Find objects Dialog
- Project Manager
|
|
TIP:
|
Build a query
| 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. |
Create a table join
- Add two table names to the Model Area.
- In the first table, click the column name that you want to join. Drag it to the corresponding column name in the second table.
- When the join is successfully created, SQL Modeler draws a connecting line that represents the join between the two table columns.
|
|
TIP: To specify criteria for a table join, double-click on the connecting line joining the two columns. This opens the View Joins Dialog. |
Menus in the Model Area
Right click the model
| 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. |
Right click the Table object
| 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).
|
Keyboard Shortcuts
| 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) |