on 04-18-2006 4:50 PM
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
Hi Jak,
DELETE ZTAB FROM WA.
or
DELETE ZTAB FROM TABLE itab.
Regards
vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Yes I've just remembered that stamanent DELETE FROM without WHERE CLAUSE doesn't work in your release.
But you can use a little trick, for example if FIELD1 is the first key:
RANGES R_FIELD1 FOR ZTABLE-FIELD1.
DELETE FROM <ZTABLE> WHERE FIELD1 IN R_FIELD1.
and then
INSERT <ZTABLE> FROM TABLE ITAB.
Max
Yes Vijay,
Your right.That worked.
But i have strange scnario here.
I have table like ztab.
1.delete ztab. It works fine.
2.i copied ztab to ztab_cc in se11.and activated ztab_cc.
i know there will not be entries in ztab_cc.
3.then i given delete ztab_cc...but it is giving errorlike into clause is missing at slect or from addition at delete..etc..
Thanks in Advance
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use
delete from ztab.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
DELETE FROM ZTAB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.