deleting tables

[Former Member]

Hi All,

What are the different ways of deleting a table in SAP. how Can you delete all table entries while keeping its structure. What does truncate command do? what are the diifferent transactions used to delete tables and what are the differenet scenarios in which to use them?

Thanks in advance

Cyrus

[Former Member]

Thanks Mrutyun,

You gave me exactly the info i was looking for. I wanted to ask you about se14, will it do the same as se11.

My developers asked me about the different ways to delete table entries and which method to use in what scenarios.

Thanks

Cyrus

[Former Member]

HI

GOOD

TRUNCATE: truncate table emp; " then the data inthe table willbe deleted" but the sturucture is available> if u type--- desc empthen it give the structure of that table.DROP: drop table emp:after that what ever command u r using on emp table it will give error. bcuz the table object emp is not available in database

SE11-U CAN USE THIS TCODE TO DELETE THE TABLE.

IF YOU WANT TO DELETE THE TABLE COMPLETELY THAN YOU CAN USE THIS TCODE.

THANKS

MRUTYUN

[RichHeilman]

You can delete custom tables via SE11, you can delete just the data from the table using SE14.

Regards,

Rich Heilman