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

delete data from table in db

Former Member — Wed, 20 Dec 2006 10:04:56 GMT

Hallow I build a table with data in se11 and I wont to delete all the data from their .how can I do that. I try with (buield program)

<b>DELETE from YHR_EX_MUSHLACH.

COMMIT WORK.</b>

And its not working what can I do , if it impoosible how can I write a select statement that I can delete 100 record from my table .(what I do from select into)

*SELECT id_number pernr hagbla1 rama

*FROM yhr_ex_mushlach

into ?

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:08:04 GMT

GO TO SE16

CHECK ALL TABLE CONTENTS IN MENU TABLE ENTRIES CLICK DELETE ALL.

REGARDS

SHIBA DUTTA

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:08:50 GMT

Hi,

You can select the data into an internal table. I think you can use Sy-dbcnt for getting the 100th record and deleting it.

-Priyanka

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:09:26 GMT

Hi ,

Try using

DELETE from YHR_EX_MUSHLACH where cond.

try to give a condition which is true for all records.

an example would be as below , assume field1 is a prinmary key field then command will be

DELETE from YHR_EX_MUSHLACH where field1 is not NULL.

Regards

Arun

Message was edited by:

Arun R

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:10:16 GMT

GOTO SE14 AND AND DELETE ALL THE DATA.

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:12:36 GMT

hi shiba i check it i have myby 10000 recored and this commend dont do anything

regards

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:13:01 GMT

first you append all records to itab1 by select statement .

and use it

-DELETE itab1 FROM idx1 TO idx2.

eg: if need to delete 100 records.

delete itab1 from 1 to 100.

it will be use ful.

Regards.

Jay

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:14:02 GMT

hey,

Go to se14 enter your table name and enter there is a radio button delete all data. check it and say adjust table it should work

santhosh

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:14:46 GMT

Hi antonio ,

Did you try the solution i suggested.

Or another alternative is

the code below

<b>Data : it_1 type table of R_EX_MUSHLACH..

start-of-selection.

select * into table it_1 from R_EX_MUSHLACH..

delete R_EX_MUSHLACH from table it_1.</b>

Regards

Arun

Message was edited by:

Arun R

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:15:36 GMT

Try this code. It is working.

Tables: zemp_info.

delete from zemp_info.

if sy-subrc = 0.

write:/ 'Deleted'.

else.

write:/ 'Not'.

endif.

Regards

Haritha.

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:16:25 GMT

TRY THIS

SELECT * FROM DBTAB INTO TABLE ITAB.

DELETE dbtab FROM TABLE itab.

REGARDS

SHIBA DUTTA

Re: delete data from table in db

Former Member — Wed, 20 Dec 2006 10:21:14 GMT

did you tried going to se14 and deleting all data option.

Else if you wanna write a program

then simply

write:

delete from itab

where <some condition which is true for all >

commit work.