[480] in sapr3-soft
deleting tables
daemon@ATHENA.MIT.EDU (=?iso-8859-1?Q?=22Frode_R=F8ed=22?)
Thu Oct 9 08:37:27 1997
To: sapr3-soft@MIT.EDU
Date: 9 Oct 1997 07:30:20 -0500
From: =?iso-8859-1?Q?=22Frode_R=F8ed=22?= <frode.roed@winhlp.net> (by way of)
Hi
I hope this is the right group for my question.
I'v only worked with SAP for one and a half moth as a ABAP/4 programmer,
so I am still trying to find my way around SAP.
My question is: how do I delete the contents of a tabel ?
I have a table (database table, not internal) call ZNEWS and I want to
empty it befor I fill it up with data again.
I tried "delete znews." but the compiler told me that I needed a where
statement. So I tried "delete znews where '1' = '1'. " This would have
worked with normal SQL but the compiler still complained. What does it
take to delete a table ??
Frode Roed
PS: please excuse my horrible english....
----------------------------------------------------
comp.soft-sys.business.sap is a moderated newsgroup.
Postings are archived and available from the
Realtime USA web site at http://www.realtimeusa.com
----------------------------------------------------
