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:

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.