Skip to Content
avatar image
Former Member

Delete Table entries

Hi Friends,

Can any body tell me which is the better method to delete the table entries?..

in 4.6C version if i give

Here no itab)

Delete ztab.

It is giving error like into clause is missing

Thanks in Advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Apr 18, 2006 at 03:55 PM

    Hi Jak,

    DELETE ZTAB FROM WA.

    or

    DELETE  ZTAB  FROM TABLE itab.

    Regards

    vijay

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2006 at 03:52 PM

    Hi

    Use DELETE FROM statament:

    DELETE FROM <ZTABLE> -> All hits'll be deleted.

    You can also indicate some conditions if you don't need to delete whole table.

    DELETE FROM <ZTABLE> WHERE .....

    Max

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2006 at 03:53 PM

    DELETE FROM ZTAB.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2006 at 03:54 PM

    Use

    delete from ztab.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2006 at 03:58 PM

    Hi,

    check this..

    DELETE 
    
    
    Deleting from a Database Table 
    - DELETE FROM  dbtab. or 
    DELETE FROM (dbtabname). 
    - DELETE  dbtab      FROM wa. or 
    DELETE (dbtabname) FROM wa. 
    - DELETE  dbtab      FROM TABLE itab. or 
    DELETE (dbtabname) FROM TABLE itab. 
    - DELETE  dbtab. or 
    DELETE *dbtab. 
    - DELETE  dbtab VERSION vers. or 
    DELETE *dbtab VERSION vers.

    Regards

    vijay

    Add comment
    10|10000 characters needed characters exceeded