DELETE - delete a data cluster


Basic form

DELETE FROM DATABASE dbtab(ar) ID key.

Addition



... CLIENT f

Effect

Deletes the data cluster stored in the table dbtab under the area ar (constant) and the ID key (field or literal) (EXPORT ... TO DATABASE ... ).

Example

TABLES INDX. DATA: BEGIN OF TAB OCCURS 1, CONT(30), END OF TAB. DATA: FLD(30) TYPE C. ... EXPORT TAB FLD TO DATABASE INDX(AR) ID 'TEST'.

You can delete this data cluster with the following statement:
DELETE FROM DATABASE INDX(AR) ID 'TEST'.

Addition 1

... CLIENT f

Effect

Deletes the data cluster in the client specified in the table f (only with client-specific import/export databases).

Example

TABLES INDX. DELETE FROM DATABASE INDX(AR) CLIENT '001' ID 'TEST'.


Index
© SAP AG 1996