delete all content in a database table

[Former Member]

i want to initialize a database table just before my specific program terminate.

can i use the

delete databasetable

Edited by: Matt on Nov 7, 2008 8:04 AM

[Former Member]

Hi try,

delete from dbtab client specified where mandt = sy-mandt.

Darren

[Former Member]

Yes, if it is a custom table which you are using just for your program purpose. Please check the dependency before you write your code for that.

Thanks,

Jayant

[Former Member]

Hi,

If you want to delete all the contents of database table, use the following code:

data itab type standard table of dbtab.

select * from dbtab into table itab.

delete dbtab from table itab.

Hope this will help.

Regards,

Nitin.