Delete clause clarification

Hi

You can't use the command DELETE alone, becouse you have to indicate which record you want to delete, so:

A)

SELECT * FROM <TABLE> WHERE...

DELETE <TABLE>.

ENDSELECT.

B) DELETE FROM <TABLE> WHERE ......

C) DATA WA LIKE <TABLE>.

.......

DELETE <TABLE> FROM WA

D) DATA ITAB LIKE STANDARD TABLE OF <TABLE>.

..........

DELETE <TABLE> FROM TABLE ITAB.

Max

Hi Raja,

"delete dbtable" will work if you have defined

"Tables dbtable" and this will delete only record that matches the workarea dbtable.

To delete in one shot -

DELETE FROM DBTABLE.

But if its a client soecific table it will delete data in current client only . If you want to delete data in all clients use "client specified".

Cheers

Hi,

If you want to delete all table entries without ABAP coding, go to tr.code SE11 -> Utilities -> Database utility (Transaction SE14).

Svetlin

Hi Max & Sanjay,

DELETE from dbtab not working...

Syantax error: delete from itab shud be followed by where clause...

Help me out.

I have to do this programatically..

GOT it from documentation.

check the following

<b>Note:</b>

To delete all the lines in a table, you must specify a WHERE condition that is true for all lines. You can achieve this with

... WHERE f IN itab

If the internal table itab is empty, such a condition would select all lines.

Can anybody suggest me with out using where clause to delete table data in one shot..?

Thanks

Hi raja,

check this...

http://help.sap.com/saphelp_erp2004/helpdata/en/1e/f5383fe58d5900e10000000a114084/frameset.htm

regards,

venu.