Support Questions

Find answers, ask questions, and share your expertise

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.