Hyperlink Object Actions

Go Up to Automated Error Detection and Coding Aid Features

Hyperlinks let you invoke object actions against object names referenced in an ISQL Editor script. A configured keystroke combination (default, CTRL+right-click) opens a menu with commands specific to the supported object type:

Note: In addition to the object type-specific options, the context menu also includes SQL editor options typically available when right-clicking in the editor.

The following table shows the object action availability in DBArtisan for supported object type hyperlinks in the SQL editor:

Action (and notes)		Object type
		Table	View	Function	Procedure	Package	Package Body
Build Query	For more information, see Query Builder	✓	✓
Compile	For more information, see Script/File Execution Facilities					✓	✓
Create Like		✓
Create View		✓
Debug	For more information, see IDERA SQL Debugger			✓	✓
Describe	For more information, see Describe Window	✓	✓	✓	✓
Drop		✓	✓	✓	✓	✓	✓
Edit Data	For more information, see Data Editor	✓
Execute	For more information, see Script/File Execution Facilities			✓	✓
Extract		✓	✓	✓	✓	✓	✓
Import Data From File	For more information, see Import Data	✓
Migrate	For more information, see Using the Schema Migration Wizard	✓	✓	✓	✓
Open	For more information, see Modifying objects using editors	✓	✓	✓	✓	✓	✓
Report		✓	✓	✓	✓	✓	✓
Select * From		✓	✓

The following table shows the object action availability in Rapid SQL for supported object type hyperlinks in the SQL editor:

Action (and notes)		Object type
		Table	View	Function	Procedure	Package	Package Body
Build Query	For more information, see Query Builder	✓	✓
Compile	For more information, see Execution and Execution-related SQL Editor options					✓	✓
Create Like		✓
Create View		✓
Debug	For more information, see IDERA SQL Debugger			✓	✓
Describe	For more information, see The Rapid SQL Describe Window	✓	✓	✓	✓
Drop		✓	✓	✓	✓	✓	✓
Edit Data	For more information, see Data Editor	✓
Execute	For more information, see Execution and Execution-related SQL Editor options			✓	✓
Extract		✓	✓	✓	✓	✓	✓
Import Data From File	For more information, see Import Data	✓
Open	For more information, see Modifying objects using editors	✓	✓	✓	✓	✓	✓
Report		✓	✓	✓	✓	✓	✓
Select * From		✓	✓

Before using the Hyperlinks feature, complete the following setup tasks:

• Ensure that the object types for which Hyperlink object actions are to be available, are being indexed in the datasource index. For details, see ISQL Options - Code Assist - Advanced Tab on page 214.
• Ensure that the Hyperlink feature has been enabled, the appropriate keystroke combination configured, and the menu details selected. For details, see ISQL Options - Code Assist - Main Tab on page 211.

Once setup tasks are complete, the Hyperlinks feature is available in the SQL Editor.

To invoke an object action using the Hyperlink feature

1. Use the configured keystroke combination anywhere within the text of an object name reference for a supported object type.
2. Select an object action from the context menu. For more information, see the online help for the selected action.