delete all data in db table

[Former Member]

Hi,

how can I delete all data in db table.

Reagards

ertas

[Former Member]

Hi,

how can I delete all data in db table.

Reagards

ertas

[Former Member]

hi use the command .

delete tabname

regards,

venkat.

[Former Member]

hi,

just to this way .. in a simple program..

 select * from <dbtable> into table itab.
 delete <dbtable> from table itab . 

[Former Member]

hi,

what I mean is a db table

Regards

ertas

[Former Member]

hi,

go to SE11 and give the data base ztable name and press delete button(Shift + F2) to delete the ztable. The standard tables cannot be deleted ..

Regards,

santosh

[Former Member]

HI,

in that case ... just write a simple program and call the below statement in that ...i.e,

 * Note the below statement just deletes entire the data from the data base table ... 
 delete <dbtable>. 

Regards,

Santosh

[Former Member]

Hi Kumar I would like to delete the content of this db table .

How is it with abap possible ? I need a delete command without where condition

Regards

ertas

[Former Member]

Just call

Delete <Tablename> .

where <Tablename> will be your database table name

[Former Member]

Hi,

You can use

Delete dbtab.

Pls reward if found helpful.

[Former Member]

Hi,

If you want to delete the data directly from the db table.

Just go in transaction SE14, write the table name press edit

click on radio button 'delete data' and thn click on 'activate and adjust database'.

Hope this helps,

Regds,

Seema