topic Re: delete all content in a database table in Application Development and Automation Discussions

delete all content in a database table

Former Member — Thu, 06 Nov 2008 13:35:54 GMT

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 — Thu, 06 Nov 2008 13:38:12 GMT

Hi try,

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

Darren

Former Member — Thu, 06 Nov 2008 13:39:04 GMT

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 — Thu, 06 Nov 2008 13:41:04 GMT

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.