Data source discovery and import
- Auto-discover data sources - create new data source with the registration wizard, or import data sources from DTP and all Quest TOAD products.
- Explorer view actions Connect - disconnect, delete, refresh, or duplicate data sources and extract DDL or drop multiple or individual database objects
directly from the explorer.
- Compile stored routines - Compile the stored routine with debug options and/or compile dependent objects.
SQL Editing
- Code assist and code assist offline Lists - context-sensitive suggestions as you type and is available offline.
- Context-sensitive DBMS actions DBMS actions - such as Extract and Drop, are available directly in the context menu of the appropriate tokens in the SQL editor.
- Code formatting and profiles Code folding - syntax coloring, comment toggling, and other auto formatting features make it easy to read, navigate, and edit
large SQL files. Customise and share various SQL formatting options by creating SQL formatting profiles.
- Outline view - A hierarchical structure of a SQL file makes it easy to navigate to a particular block of code in a large file and browse that code
without opening the file.
SQL Validation
- Syntax & semantic validation - Validate SQL files and fl ags all DBMS-specifi c parser violations or references to objects not found in the target database.
- Real-time validation Error - notations appear at the exact location of the error in real-time.
- Auto-validation of files - Revalidation automatically occurs when SQL fi les have been added, removed or modified in the workspace.
SQL Execution
- Executing SQL scripts - Run SQL scripts with a single click, customise the auto-commit feature.
- Run stored routines - Right click on the desired object to execute a stored routine and enter input parameters when prompted.
Search
- Database object look-up - Quickly find and extract any database object from a connected data source, regardless of platform.
- Database search - Easily search for declarations and references to database objects.