How to delete whole database table

Former Member · ‎2008 Jan 15

Hi there,

I am trying to delete a dbtab at one shot using the statement "DELETE dbtab" (dbtab is the database table name).

but it is returning sy-subrc = 4.

can u plzz help me to solve this issue.

Former Member · ‎2008 Jan 15

Regards

Thomas

Former Member · ‎2008 Jan 15

Regards

Thomas

Former Member · ‎2008 Jan 15

Hi,

data itab type standard table of dbtab.

select * from dbtab into table itab.

delete dbtab from table itab.

Former Member · ‎2008 Jan 15

Hi Hardik,

In case you want to delete the database table for refreshing it for a reason (one time) you can do it from transaction SE14.

Select option "Activate and Adjust Database Table" and option "Delete data".

Regards,

Aditya

Former Member · ‎2008 Jan 15

thanx for ur reply frnds.....but i can't populate itab as the table is having more than 28 lacs records.

and i need to write code in a program so cant use TC se14