SQL Code Assist is an interface component that enables the development and formatting of SQL code for the purposes of creating and modifying database objects. It provides a front-end application for the delivery of code through its object code extraction capabilities.
Code Assist provides a number of key features that assist in the coding process, ensuring greater accuracy in coding, faster development cycles, and a general increase in efficiency overall.
The following key features are provided with SQL Code Assist:
- Code Extraction
- Code Highlighting
- Automatic Error Detection
- Code Complete
- Hyperlinks
- Code Formatting
- Code Folding
- Code Quality Checks
- SQL Execution
- Configuring SQL Execution Parameters
In order to access SQL Editor, you need to create a new file or edit existing code from Data Source Explorer.
Additionally, SQL Project Explorer provides a tree structure for all files created in DB Optimizer. You can access files from here by double-clicking the file name you want to open as well.
To create a new file
- Choose File > New > SQL File. A blank instance of SQL Editor appears in the Workbench. If you save this file, it is automatically added to the SQL Project Explorer.
To edit an existing file
- Use Data Source Explorer or Project Explorer to navigate to the code you want to modify, and then double-click it. An instance of SQL Editor appears in the Workbench, populated with the extracted code of the specified object or SQL project file.