topic Re: Delete rows in database table in Application Development and Automation Discussions

Delete rows in database table

Former Member — Fri, 23 Feb 2007 13:52:19 GMT

Hi ,

I need to delete all the records in the dtabase table and insert new data into it.

I use the below code , but the delete returns with sy-subrc 4 and doesnt delete the records in table ?

delete ZZVT2_BW.

commit work and wait.

insert ZZVT2_BW from table itab_zvt2 accepting duplicate keys.

commit work and wait.

Thanks,

Re: Delete rows in database table

Former Member — Fri, 23 Feb 2007 13:53:26 GMT

Hello,

DELETE ZZVT2_BW WHERE.....

Vasanth

Re: Delete rows in database table

Former Member — Fri, 23 Feb 2007 13:55:29 GMT

Hi ,

u can use DELETE FROM dbtab.

in your case write

delete from ZZVT2_BW.

INSERT dbtab FROM TABLE itab.

Regards,

Sruthi.v

Re: Delete rows in database table

Former Member — Fri, 23 Feb 2007 13:56:18 GMT

Use

<b>DELETE dbtab FROM TABLE itab.</b>

Re: Delete rows in database table

Former Member — Fri, 23 Feb 2007 14:01:45 GMT

Deleting from a Database Table

<b>- DELETE FROM dbtab. or

DELETE FROM (dbtabname).</b>

- DELETE dbtab FROM wa. or

DELETE (dbtabname) FROM wa.

- DELETE dbtab FROM TABLE itab. or

DELETE (dbtabname) FROM TABLE itab.

- DELETE dbtab. or

DELETE *dbtab.

- DELETE dbtab VERSION vers. or

DELETE *dbtab VERSION vers.

use the bold text in u r program

Re: Delete rows in database table

Former Member — Fri, 23 Feb 2007 14:01:52 GMT

Depending on the size of the table you might want to check this <a href="https://forums.sdn.sap.com/click.jspa?searchID=-1&messageID=2749963">thread</a>.

It basically describes how to use function module DD_DATABASE_UTILITY to delete big tables (i.e. deleting ALL records).

Guenther