topic Delete statement in Application Development and Automation Discussions

Delete statement

Former Member — Fri, 30 May 2008 10:46:39 GMT

HI Frds

How write a delete statement to delete entries from DB(Data Base).

Pls can one help me with this.

Thanks

Pari

Re: Delete statement

prasanth_kasturi — Fri, 30 May 2008 10:47:45 GMT

hi,

DELETE dbtab

Syntax

DELETE { {FROM target [WHERE sql_cond]}

| {target FROM source} }.

Effect

The statement DELETE deletes one or more rows from the database table specified in target. The rows that are to be deleted are specified either in a WHERE condition sql_cond or with data objects in source.

System Fields

The statement DELETE sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc Meaning

0 A least one row was deleted.

4 At least one row could not be deleted, since it was not found in the database table.

The statement DELETE sets sy-dbcnt to the number of deleted rows.

Note

The rows are deleted permanently from the database table in the next database commit. Until then, you can cancel the deletion using a database rollback. The statement DELETE sets a database lock until the next database commit or database rollback. If used incorrectly, this can lead to a deadlock.

The number of rows that can be deleted within a database LUW in the tables of a database has a specific restriction for each database, as each database system can only manage a limited amount of data in the rollback area, and a limited number of locks.

regards

prasanth

Re: Delete statement

Former Member — Fri, 30 May 2008 10:47:53 GMT

Hi,

You can use Delete from databasetable.

i.e. DELETE FROM dbase.

Edited by: Poonam Naik on May 30, 2008 12:50 PM

Re: Delete statement

Former Member — Fri, 30 May 2008 10:48:24 GMT

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

rwrd if helpful

Bhupal

Re: Delete statement

Former Member — Fri, 30 May 2008 10:48:28 GMT

use this

delete dbtabname where werks = '1000'.

regards,

venkat

Re: Delete statement

Former Member — Fri, 30 May 2008 10:49:08 GMT

There are several ways, these are the main ways:

DELETE FROM <DATABASE TABLE> WHERE <CONDITION>.

SELECT * FROM <DATABASE TABLE> WHERE <CONDITION>.
   DELETE <DATABASE TABLE>.
ENDSELECT.

Max

Re: Delete statement

Former Member — Fri, 30 May 2008 10:49:52 GMT

Hi,

PARAMETERS p_carrid TYPE sflight-carrid.

DELETE FROM sflight

WHERE carrid = p_carrid AND

fldate = sy-datum AND

seatsocc = 0.

2) DELETE sflight FROM TABLE sflight_key_tab.

Narasimha

Re: Delete statement

Former Member — Fri, 30 May 2008 10:52:09 GMT

DELETE <name dbtab> [where ..condition..]

Be careful it will delete the records can not rollback.

from

sujit

Re: Delete statement

Former Member — Fri, 30 May 2008 11:17:55 GMT

DELETE ( fieldname) from TABLENAME where <condition>.

hope it helps.

Reward if useful.

Regards

Megha Sharma