topic Re: Delete Database in Application Development and Automation Discussions

Delete Database

Former Member — Thu, 19 Oct 2006 22:59:35 GMT

Hello friends,

I have to delete all records from a database table. Its more than some 1000 records.

Its a customized table and has the table mainteance generator. so when i go to se16 it dosent give me the option to delete the records. Is there a way to do so, I have a program to delete but was kind of thinking to do wihout program.

Shejal.

Re: Delete Database

Former Member — Thu, 19 Oct 2006 23:01:30 GMT

Hi,

If you have table maintenance..Go to SM30..

Give the table name..

Get in to change mode..

Press select all button (F7)..

Press the delete button (Shift + F2).

THen save..

THanks,

Naren

Message was edited by: Narendran Muthukumaran

Re: Delete Database

RichHeilman — Thu, 19 Oct 2006 23:03:36 GMT

Easy way to delete all records is to use SE14, enter table name and hit enter. Mark the radiobutton for "Delete Data" and click the "Activate and Adjust" button. Table will be cleared.

Regards,

RIch Heilman

Re: Delete Database

Former Member — Thu, 19 Oct 2006 23:07:42 GMT

Narendran,

I dont own this table.

However when i go to SM30 i dont have an option for change mode.

Rich,

Do i need the ownership of the table to do the way you have specified.

Shejal.

Re: Delete Database

RichHeilman — Thu, 19 Oct 2006 23:09:22 GMT

You should be able to do any table including standard SAP tables so...... be careful!!!

Regards,

Rich Heilman

Re: Delete Database

Former Member — Thu, 19 Oct 2006 23:12:23 GMT

Hi,

Press the maintain Button..That is the change mode..

Thanks,

Naren

Re: Delete Database

Former Member — Thu, 19 Oct 2006 23:14:09 GMT

Thanks, Rich and Naren.

Shejal Shetty.