topic Re: Drop Table in Application Development and Automation Discussions

Drop Table

Former Member — Fri, 17 Jul 2009 08:02:39 GMT

Hi experts,

i have transparent table and i would like to use faster delete

i don't want to use

DELETE FROM table CLIENT SPECIFIED WHERE mandt = sy-mandt, it takes much time for mil. rows.

Does ABAP know something similar as DROP TABLE

Thanks

Martin

Re: Drop Table

Former Member — Fri, 17 Jul 2009 08:05:12 GMT

erm. you are aware that drop table wont delete your records but the whole table?

remove your client specified addition, maybe this speeds him up a bit, since you are thinking of dropping the table, there are probabaly no records you wish to keep.

Re: Drop Table

Former Member — Fri, 17 Jul 2009 08:07:29 GMT

Hello,

If allowed in your project or in program you can also you DROP TABLE using native SQL.

Sudo Syntax is:

EXEC SQL.

DROP TABLE <table_name>.

ENDEXEC.

Note: Native SQL's are avoided due to the performance overhead and are limited to support of specific database used at backend.

Thanks,

Augustin.

Re: Drop Table

Former Member — Fri, 17 Jul 2009 08:07:57 GMT

sorry, i thought TRUNCATE instead of DROP table of course

Re: Drop Table

SimoneMilesi — Fri, 17 Jul 2009 08:09:48 GMT

The FM 'DB_TRUNCATE_TABLE'.

There are a bunch of FM about DB management.

You can go to SE37 and search 'DB*' FM

There is also the DB_DROP_TABLE FM..

Edited by: Simone Milesi on Jul 17, 2009 10:09 AM

Re: Drop Table

Former Member — Mon, 09 Jun 2014 12:21:24 GMT

It is possible delete table using ABAP variable?

like this (but give a error)

DATA: tabName TYPE string.

tabName = 'tab01'.

EXEC SQL.

DROP TABLE :tabName

ENDEXEC.

Thank you