topic Re: how to delete the database table in Application Development and Automation Discussions

how to delete the database table

Nawanandana — Wed, 11 Oct 2006 03:20:43 GMT

hi all

i want to delete the data from the custrmize table so if u can heilp me to do that....not the internal table ..i write the code but that using that code i can delete only one raw.. but i want to delete all raw in my table..

ZLAB_SUBMIT-SHADE = '1'.

ZLAB_SUBMIT-SUBMIT = '1'.

ZLAB_SUBMIT-RM = 'RINGS'.

ZLAB_SUBMIT-REMARKS = 'Approved'.

ZLAB_SUBMIT-AP = ''.

ZLAB_SUBMIT-USNAM = 'INDIKAF'.

ZLAB_SUBMIT-CPUDT = '05.10.2006'.

ZLAB_SUBMIT-CDATE = '05.10.2006'.

ZLAB_SUBMIT-CPUTM = '21:29:19'.

DELETE ZLAB_SUBMIT.

regard

nawa

this is my code....

Re: how to delete the database table

former_member188770 — Wed, 11 Oct 2006 03:22:13 GMT

Hi,

U will have to use the below statement

Delete from ZLAB_SUBMIT where (Condition).

Thanks,

Poonam

Re: how to delete the database table

former_member186741 — Wed, 11 Oct 2006 03:32:34 GMT

to delete all entries from the table you need to supply a where clause which will be true for all records. If your table is client dependent you can say:

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

Otherwise pick something you know will NEVER be true and use <> that:

delete from zlab_submit where shade <> '?'.

Re: how to delete the database table

Former Member — Wed, 11 Oct 2006 03:37:57 GMT

A where clause is mandatory while you delete from a table. Specifying the client is the most efficient way.

Delete from ZLAB_SUBMIT client specified where mandt = sy-mandt.

Re: how to delete the database table

Former Member — Wed, 11 Oct 2006 03:40:03 GMT

hi,

use Delete from <table> where <conditon>

Re: how to delete the database table

gopi_narendra — Wed, 11 Oct 2006 03:49:37 GMT

If you just want to delete all the rows from a program

use DELETE from <ZTABLE> where <CONDITION>.

or else if u have created a table maintenance generator, goto SM31, select all entries and delete them.

Regards

- Gopi

Re: how to delete the database table

jayanthi_jayaraman — Wed, 11 Oct 2006 03:59:49 GMT

Hi,

data itab type standard table of zlab_submit.

select * from zlab_summit into table itab.

delete zlab_summit from table itab.

Kindly reward points by clicking the star on the left of reply,if it helps.

Re: how to delete the database table

Former Member — Wed, 11 Oct 2006 04:07:47 GMT

Hi,

U can use the delete statement

delete from <tablename> where <condition>.