topic Re: delete all data in db table in Application Development and Automation Discussions

delete all data in db table

Former Member — Mon, 28 Apr 2008 08:43:51 GMT

Hi,

how can I delete all data in db table.

Reagards

ertas

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 08:45:03 GMT

hi use the command .

delete tabname

regards,

venkat.

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 08:47:09 GMT

hi,

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


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

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 08:51:52 GMT

hi,

what I mean is a db table

Regards

ertas

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 08:53:54 GMT

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

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 09:09:14 GMT

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

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 09:11:07 GMT

Just call

Delete <Tablename> .

where <Tablename> will be your database table name

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 09:13:37 GMT

Hi,

You can use

Delete dbtab.

Pls reward if found helpful.

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 09:15:59 GMT

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

Re: delete all data in db table

Former Member — Mon, 28 Apr 2008 09:29:06 GMT

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