topic Re: syntax to delete total records from database table in Application Development and Automation Discussions

syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:06:38 GMT

Hi all.

Can you pls let me know how to delete all the records from database table.Thanks in advance.

Thanks & Regards,

sami.

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:07:44 GMT

hi,

Delete <database-tab>.

in program.

Thanks

Sharath

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:08:23 GMT

Hi SAMI ,

You try this code -

DELETE   FROM   dbtab_name.

Regards

Pinaki

Edited by: Pinaki Mukherjee on Feb 16, 2009 7:12 AM

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:08:57 GMT

Hi Sami,

Use DELETE command. Keep ur cursor on DELETE, press F1 and you will get the syntax for DELETE.

Thanks,

Ibrahim

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:09:06 GMT

DELETE FROM dbtab

Re: syntax to delete total records from database table

gaursri — Mon, 16 Feb 2009 06:09:45 GMT

Hi Sami,

You can use

DELETE  FROM sflight.

or you can specify the where condition.

Hope your query is resolved.

Have a best day ahead.

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:10:32 GMT

(this can be along way to do.)

u can fetch all the recoreds into an internal table. loop at itab.

DELETE itab FROM 1.

endloop.

modify database table from itab.

Edited by: Kalyan Chakravarthi on Feb 16, 2009 7:13 AM

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:11:29 GMT

Hello,

DELETE { {FROM tgt [WHERE sql_cond]}

| {tgt FROM source} }.

check this....

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:12:25 GMT

http://help.sap.com/saphelp_nw04/helpdata/en/c4/3a7886505211d189550000e829fbbd/frameset.htm

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:15:31 GMT

Hi,

To delete data from the data base.

Simply wirte




Delete dbtab.    " delete is the key word    dbtab pass the database table name

Thanks

Arun

Re: syntax to delete total records from database table

dev_parbutteea — Mon, 16 Feb 2009 06:17:07 GMT

Hi,

Go to transaction SE14, select delete data radio button and click on Activate and Adjust database.

Regards.

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:18:25 GMT

Hi Sami,

I think you should not remove the habit of reading the SAP help provided just because you get answers in SDN...for finding formulas you can always refer help, because it might give you a perfect syntax based on the requirement as in SDN you will ask for some requirement and if its not clear you may end up getting an incorrect syntax...

just write the keyword delete in the ABAP editor and then press F1, you can get all the information..

Regards,

Siddarth

Re: syntax to delete total records from database table

Sm1tje — Mon, 16 Feb 2009 06:18:49 GMT

Sami,

before even considering of deleting any records from a database table, you might wanna think about the following. If there any other tables, referencing the table you are trying to delete the records from, this will have a major impact on the integrity of your database.

As a rule of thumb: Never ever delete any records from database by using the DELETE statement, unless you are absolutely sure this has no further impact. In most cases, this will only be when you are doing this on a custom table (a non-standard SAP table).

So in case of standard table, try to find the standard delivered function modules for this.

Just a word of advice.

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:22:36 GMT

Hi.

Just write the following

DELETE FROM (NAME OF THE TABLE).

DELETE FROM MARA. (Where mara is the name of the d/b table)

You can even add the where condition based on your requirent for example you won to delete specific records

DELETE FROM MARA WHERE MATNR = -

Regards

Sumeet malhotra

Re: syntax to delete total records from database table

Former Member — Mon, 16 Feb 2009 06:23:37 GMT

Use FM SUBST_DELETE_TABLE_CONTENT