Right-click feature
Go Up to Session 3: Scripting
Similar to the Code Generation Facility, the “right-click” code generation feature can be used to create complete procedures, functions or packages revolving around views or tables.
- From the Datasource Navigator tree, expand the SAMPLE_DATASOURCE > AdventureWorks > Tables sub-node.
- Right-click on the Vendors table.
- Select Generate > Procedure > Select.
- Select Name as the input column, and leave all output columns selected.
- Click OK and the DDL to create the procedure will be generated and displayed in the DDL Editor. You can edit the name of the new procedure and any of the generated code. Name the new procedure sample_select_vendors2.
- Click on the Execute or Step Execute button to submit the DDL and create the procedure.
Proceed to Automated error detection and coding assistance.