EMS logo

Products Navigation

SQL Manager for DB2

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for DB2

On-line Documentation

DELETE procedure


The Delete section of the Create Procedures from Table dialog provides the definition of the DELETE procedure generated from the table.

 

Tables - Create Procedure from Table - DELETE

 

View schema

Select schema for the procedure using the drop-down list.

 

Name

Specifies procedure name (if necessary, you can edit the one assigned by default).

 

The lower area represents the DELETE procedure definition as SQL statement. It is possible to edit the definition directly using the editor area to make appropriate changes.

Edit the block of statements within the BEGIN / END pair according to your needs.

For your convenience the syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with SQL Editor area and Using the context menu.