Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete whole data from a user created Table(ZAHA).

Former Member
0 Kudos

I want to know that how to delete whole data from user created table or we can say table whose name started with Z or Y.

1 ACCEPTED SOLUTION

former_member386202
Active Contributor
0 Kudos

Hi,

Try like this

DELETE dbtab FROM dbtab.

Regards,

Prashant

7 REPLIES 7

Former Member
0 Kudos

Hi,

Use the following synatax,

DELETE <tablename>.

JozsefSzikszai
Active Contributor
0 Kudos

with DELETE statement...

Former Member
0 Kudos

Sunil,

Do like this

Delete <DBTABLE> where <Keyfield> is initial. 
Commit work

.

Regards,

Satish

matt
Active Contributor
0 Kudos

Programmatically, use the procedures above. Non-programmatically, use SE14 - the DB Utility.

matt

0 Kudos

Thank You.

former_member386202
Active Contributor
0 Kudos

Hi,

Try like this

DELETE dbtab FROM dbtab.

Regards,

Prashant

Former Member
0 Kudos

Thanks a lot for the answer.