topic Re: Deleting Database Contents in Application Development and Automation Discussions

Deleting Database Contents

Former Member — Mon, 19 Feb 2007 15:03:52 GMT

Hi,

I want to delete the contents of my table. I have the following requirements:

(*) i want to specify the table name dynamically

(*) i dont want to provide any where/from condition in the delete statement

(*) i want to delete all the contents of the database.

<b>I am working on 4.0B version.</b>

Is this possible ?

thanks

Re: Deleting Database Contents

Former Member — Mon, 19 Feb 2007 15:13:11 GMT

Hi Navneeth,

PARAMETERS:

pa_dbnam TYPE tabname.

DELETE FROM (pa_dbnam)

WHERE mandt = syst-mandt.

Ofcourse this is a VERY dangerous progam!

Regards,

John.

Re: Deleting Database Contents

Former Member — Mon, 19 Feb 2007 15:15:15 GMT

hi,

i dont want to specify any where condition. and i dont have any mandt field , i want to delete a custom table

Re: Deleting Database Contents

Former Member — Mon, 19 Feb 2007 15:16:43 GMT

Personally, I wouldn't do this, but this should meet your requirements:


REPORT ztest MESSAGE-ID 00.
DATA: tab(10) VALUE 'ZTAB'.
DELETE FROM (tab).

Rob

Re: Deleting Database Contents

Former Member — Mon, 19 Feb 2007 15:21:56 GMT

HI,

Its now working in 4.0B its giving a error

"DELETE FROM dbtab" must be followed by "WHERE".

Re: Deleting Database Contents

Former Member — Mon, 19 Feb 2007 15:27:38 GMT

Hi,

Do you have this standard program RADCVBTC in 4.0B?

If you do then you can use to delete all contents of your custom program.

Also you can use database utility (SE14) to delete as well (if exits in 4.0B).

Regards,

Ferry Lianto

Re: Deleting Database Contents

Former Member — Mon, 19 Feb 2007 15:50:04 GMT

Hi,

Make use of this:

Delete Dbtab(D/b table) from itab.

this will delete all the contents of the d/b table ,

urs,

seshu

Re: Deleting Database Contents

Former Member — Mon, 19 Feb 2007 16:47:36 GMT

Then you will have to go to the data dictionary for the table, find a key field and add that to a dynamic WHERE.

Rob