Data Studio Right-Click Menus
This section describes the right-click menus of Data Studio.
Object Browser Pane
The following image shows the Object Browser pane:
Right-clicking the connection profile allows you to select Rename, Edit, Remove Connection, and Properties along with Refresh options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Rename Connection | - | Renames a connection name. |
| Edit Connection | - | Modifies connection profile details. |
| Remove Connection | - | Removes the existing database connection. |
| Properties | - | Shows the properties of the connection. |
| Refresh | F5 | Refreshes the connection. |
Right-clicking the Databases group allows you to select Create Database, Disconnect All, and Refresh options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Create Database | - | Creates a new database in this connection. |
| Disconnect All | - | Disconnects all the databases of this connection. |
| Refresh | F5 | Refreshes the databases group. |
Right-clicking the active database allows you to select Disconnect from DB, Open Terminal, Properties, and Refresh options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Disconnect from DB | Ctrl+Shift+D | Disconnects the database |
| Open Terminal | Ctrl+T | Open a Terminal in this connection |
| Properties | - | Displays the properties of the database |
| Refresh | F5 | Refreshes the database |
Right-clicking the inactive database allows you to select Connect to DB, Rename Database, and Drop Database options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Connect to DB | - | Connects the database |
| Rename Database | - | Renames the database name |
| Drop Database | - | Drops the database |
Right-clicking the Catalogs group allows you to select Refresh option.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Refresh | F5 | Refreshes the schema |
Right-clicking the Schemas group allows you to select Create Schema, Grant/Revoke and Refresh option.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Create Schema | - | Creates a new schema |
| Grant/Revoke | - | Grant/Revoke access to schema group |
| Refresh | F5 | Refreshes the schema |
Right-clicking the schema allows you to select Export DDL, Export DDL and Data, Rename Schema, Drop Schema, Grant/Revoke, and Refresh options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Export DDL | - | Exports DDL of the schema |
| Export DDL and Data | - | Exports DDL and data of the schema |
| Rename Schema | - | Renames a schema |
| Drop Schema | - | Drops a schema |
| Grant/Revoke | - | Grant/Revoke Access to schema |
| Refresh | F5 | Refreshes the schema |
Right-clicking Functions/Procedures allows you to select Refresh and Create Function/Procedure and Grant/Revoke options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Create PL/SQL Function | - | Creates PL/SQL Function |
| Create PL/SQL Procedure | - | Creates PL/SQL Procedure |
| Create SQL Function | - | Creates SQL Function |
| Create C Function | - | Creates C Function |
| Grant/Revoke | - | Grant/Revoke access to Function/Procedure |
| Refresh | F5 | Refreshes the Function/Procedure |
Right-clicking Tables allows you to select Refresh and Create table and Grant/Revoke options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Create Regular Table | - | Creates Regular table |
| Create Partitioned Table | - | Creates partitioned table |
| Grant/Revoke | - | Grant/revokes access of the table |
| Refresh | F5 | Refreshes the table |
Right-clicking Views allows you to select Refresh and Create View and Grant/Revoke options.
| Menu Item | Shortcut Key | Description |
|---|---|---|
| Create View | - | Creates View |
| Grant/Revoke | - | Grant/revokes the access of views |
| Refresh | F5 | Refreshes the View |
Right-clicking PL/SQL Viewer allows you to Cut, Copy, Paste, Select All, Comment/Uncomment Lines, Comment/Uncomment Block, Compile, Execute, Add Variable To Monitor, Debug with Rollback and Debug in the PL/SQL Viewer tab.
| Right Click Options | Shortcut Key | Description |
|---|---|---|
| Cut, Copy, Paste | Ctrl+X, Ctrl+C, Ctrl+V | Clipboard operations |
| Select All | Ctrl+A | Selects the content in PL/SQL Viewer |
| Comment/Uncomment Lines | - | Comments/Uncomments selected lines |
| Comment/Uncomment Block | - | Comments/Uncomments selected Block |
| Compile | - | Compiles the function/procedure |
| Execute | - | Executes the function/procedure |
| Add Variable To Monitor | - | Adds selected variable to the monitor window |
| Debug with Rollback | - | Debugs Function/Procedure and rollback changes after debug completion. |
| Debug | - | Debugs the function/procedure |
Right-clicking the SQL Terminal allows you to Cut, Copy, Paste, Select All, Execute Statement, Open, Save, Find and Replace, Execution Plan, Comment/Uncomment, Save As, Format and Cancel in the SQL Terminal tab.
| Right Click Options | Shortcut Key | Description |
|---|---|---|
| Cut, Copy, Paste | Ctrl+X, Ctrl+C, Ctrl+V | Clipboard operations |
| Select All | - | Selects all text |
| Execute Statement | - | Executes query |
| Open | - | Opens file |
| Save | - | Saves the query |
| Find and Replace | - | Finds and replaces text in SQL Terminal |
| Execution Plan | - | Executes the query |
| Comment/Uncomment Lines | Ctrl+/ | Comment/Uncomment selected lines |
| Comment/Uncomment Block | Ctrl+Shift+/ | Comment/Uncomment selected block of lines |
| Cancel | - | Cancels execution |
| Save As | CTRL+ALT+S | Saves the query in a new file. |
| Format | CTRL+SHIFT+F | Formats the selected SQL statements. |
Right-clicking the Messages tab allows you to Copy, Select All, and Clear the contents of the Messages tab.
| Right Click Options | Shortcut Key | Description |
|---|---|---|
| Copy | Ctrl+C | Copies the text |
| Select All | Ctrl+A | Selects all text |
| Clear | - | Clears the text |
Last Article: Data Studio Toolbars
Next Article: Connection Profiles
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.