topic Re: Deleting table at database level using ABAP report in Application Development and Automation Discussions

Deleting table at database level using ABAP report

Former Member — Fri, 28 Dec 2007 08:54:48 GMT

Hi,

Can anyone tell me how we can delete a table at the database level using an ABAP report ?

Re: Deleting table at database level using ABAP report

Former Member — Fri, 28 Dec 2007 08:56:50 GMT

HI,

Yes you can do that by using Native SQL.

IF the DB is oracle then u can use Drop Ztab.

Regards

Naveen Gupta

PS: Reward Points if helpfull.

Re: Deleting table at database level using ABAP report

ThomasZloch — Fri, 28 Dec 2007 08:59:13 GMT

try FM RPY_TABLE_DELETE or DB_DROP_TABLE.

Re: Deleting table at database level using ABAP report

Former Member — Fri, 28 Dec 2007 10:27:03 GMT

Hi try like this:

In a report program give a statement like:

Drop table <tablename>.

And execute this report program. Thats all, ur table gets deleted along with its structure in the DB level.

with regards,

Hema Sundara.

Re: Deleting table at database level using ABAP report

Former Member — Fri, 28 Dec 2007 12:50:02 GMT

Thanks guys, I created the report. I have reproduced it below...

REPORT zdeletetable.

EXEC SQL.

DROP TABLE ZTESTTABLE

ENDEXEC.

IF sy-subrc = 0.

WRITE:/ 'Table ztesttable deleted from the database !'.

ENDIF.

Re: Deleting table at database level using ABAP report

Former Member — Mon, 31 Dec 2007 03:58:39 GMT

Hi ,

You can only delete a transparent table in the ABAP Dictionary when it is no longer used in other objects .

Proceed as follows to delete a table:

Enter the name of the table in the initial screen of the ABAP Dictionary.

Select object type Tables.

Choose DD object ® Delete.

A dialog box appears asking you to confirm the deletion request again.

Confirm the deletion request.

If it is no longer used in other objects and there is no longer a corresponding database table, the table is now deleted.

The corresponding table definition must be deleted on the database before deleting the table. You will be informed in a dialog box if the table was already created on the database. You must confirm that you want to delete the database table in this dialog box. If you do not do so, the deletion will be canceled.