Delete Database

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[RichHeilman]

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

Regards,

Rich Heilman

[RichHeilman]

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

[Former Member]

Hi,

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

Thanks,

Naren

[Former Member]

Thanks, Rich and Naren.

Shejal Shetty.