Displaying the Shortcut Menu
There are several ways to bring up additional menu options. Table 7 describes all of the commands.
To display commands for the Database Explorer Tree Window
✔ Do one of the following:
Shift+F10
.
Context Menu
on the keyboard.
Command |
Description |
Quick Paste |
Pastes the current object name into the Query Window. The name is inserted at the current insertion point. To insert the name at a different point, drag and drop it within the query text. |
Show Definition |
Displays the text used to create an object in the Database Explorer Tree. The DDL (data definition language) of a table, view, macro or stored procedure appears in the Answerset Window. Right-click the object to show the definition, then choose this command. |
Expand/Collapse |
Expands or collapses the display for the selected object. If the selected object has not been previously opened, the child data (for example, the list of tables) is fetched from the database. If the selected object has no children, it is removed from the tree. |
Add Database |
Adds additional databases to the Database Explorer Tree. |
Refresh Database |
Refreshes the objects shown below a database in the tree. Right-click the database to refresh, then choose this command. Note: Only object types previously expanded are refreshed. |
Remove Database |
Removes a database from the Database Explorer Tree. |
Generate SQL – The commands on this menu generate and insert SQL into the Query window. |
|
Select |
Select <a, b, c, ...> from <name>. |
Insert (Values) |
Insert into <name> ( <a, b, c, ...>) Values (<a [datatype], b [datatype], c [datatype], ...>) |
Insert (Import) |
Insert into <name> ( <a, b, c, ...>) Values (?, ?, ?, ...) |
Create |
Create Table <name> ( <a [datatype], b [datatype], c [datatype]> ) Primary Index (x) |