how to delete the database table

[Nawanandana]

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....

[Nawanandana]

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 <> '?'.

[former_member188770]

Hi,

U will have to use the below statement

Delete from ZLAB_SUBMIT where (Condition).

Thanks,

Poonam

[Former Member]

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.

[former_member186741]

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 <> '?'.

[Former Member]

hi,

use Delete from <table> where <conditon>

[gopi_narendra]

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

[jayanthi_jayaraman]

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.

[Former Member]

Hi,

U can use the delete statement

delete from <tablename> where <condition>.