:?: how to delete all the tables in the a user at a time?
satish.paluvai
-1
Light Poster
Recommended Answers
Jump to PostThere is no one command to do this, you could write a PL procedure to do it, or generate the SQL statements from USER_TABLES. Alternately some IDE's provide an easier way.
Jump to Postif in yor databse you have only tables then simply can drop user
or u can create one one store procedure to delete all table from your databse
All 6 Replies
davidcairns
1
Junior Poster
wavalker
0
Newbie Poster
debasisdas
580
Posting Genius
Featured Poster
Musta
0
Newbie Poster
bala4901
0
Newbie Poster
vijin
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.