8. OpenSQL Statements : Delete : Syntax
 
Share this page                  
Syntax
The DELETE statement has the following formats:
Interactive version:
[EXEC SQL] DELETE FROM table_name
              [WHERE search_condition];
Embedded non-cursor version:
[EXEC SQL] [REPEATED] DELETE FROM table_name
              [WHERE search_condition];
Embedded cursor version:
[EXEC SQL] DELETE FROM table_name
              WHERE CURRENT OF cursor_name;
table_name
Specifies the table for which the constraint is defined.