Support Questions

Find answers, ask questions, and share your expertise
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community BlogsRead the Announcement

Drop multiples tables

avatar
Explorer

Drop 100s tables from bash one by one, can be too slow
But Drop statement only admit ONE table
any idea/solution?

 

BR

1 ACCEPTED SOLUTION

avatar

If you want to delete a whole database you can:

 

drop database <dbname> cascade;

 

That will drop the database and all its tables.

 

View solution in original post

1 REPLY 1

avatar

If you want to delete a whole database you can:

 

drop database <dbname> cascade;

 

That will drop the database and all its tables.