topic Re: delete all the database table content in Application Development and Automation Discussions

delete all the database table content

Former Member — Fri, 15 May 2009 05:59:35 GMT

Hello Friends,

I have a z table with 5 fields (all the key fields) and I want to delete all the table content and load fresh content from internal table.

I tried using syntax 'delete ztable' but sy-subrc value is coming as 4, means no table content is getting deleted.

Please suggest me any alternative way to delete all the database table content.

Thanks in advance,

Shreekant

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:01:44 GMT

Hi,

to delete a Ztable you can use key word : ' Delete from '

delete from Ztable.

try this

safel.

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:02:26 GMT

Hi Use

DELETE from ZTABLE.

It will work

Thanks,

Mathivanan.G

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:02:56 GMT

Using DELETE tablename or DELETE FROM tablename

or by writing some piece of code u can delete

tables: ztable.

data: itab type table of ztable.

select * from ztable into table itab.

if sy-subrc = 0.

delete ztable from table itab.

endif.

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:04:01 GMT

Need to use DELETE FROM <DATABASE TABLE>. Your statment works for internal tables.

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:04:04 GMT

Hi Shreeekant,

You can do on thing. First take all data in to the internal table for which u want to delete.

then use command DELETE <databse tablename> FROM TABLE <itab> .

It will delete all the etries from ur desired table.

Rgds,

Sachin.

Re: delete all the database table content

former_member632458 — Fri, 15 May 2009 06:05:34 GMT

Hi,

Got Transaction Se14 and delete activate and adjust by selecting radiobutton

' Delete Data'

It will work Fine.

Warm Regards,

rajesh S.

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:09:44 GMT

Hi,

Use like this

delete from ztable.

Regards,

Jyothi CH.

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:39:36 GMT

Go into the data browser area of ur table..

select the record u want to delete ...

put /h in the command line and enter .....now debugger will be on ... and from here u can do somthing ...

.. i dont know whether i sld disclose it openly !! Its little sensitive..

Re: delete all the database table content

Former Member — Fri, 15 May 2009 06:42:59 GMT

Hi,

try using

delete from ztable.

This will delete all records from your ztable. After this command u can fill your ztable from itab by the following command

select *

from std table

into corresponding fields of itab.

insert ztable from table itab.

Hopefully this will solve your problem.

Regards,

Ibrar