How to empty an existing database?

[Simon Sturmer]

A while back, I moved from the Windows platform where I enjoyed using SQLYog for many years, but on Mac Sequel Pro seems the way to go. It's a brilliant application with great features.

However one feature I can't find, is how to quickly empty a database of all Tables, Views, Procedures, etc. Does this exist, or if not can someone suggest a query I can run from the Query tab to accomplish this?

Thanks in advance for your help.

[Jeremy Burns | Class Outfit]

You could do Database -> Delete database... then just add it back in again?

Jeremy Burns

Class Outfit

http://www.classoutfit.com

--
You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
To view this discussion on the web visit https://groups.google.com/d/msg/sequel-pro/-/vmu0QLBBelcJ.
To post to this group, send email to seque...@googlegroups.com.
To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.

[Peter Cawkwell]

I know this question is quite old now but it baffled me too for a while.

Having spent a few months deleting and recreating the DB as Jeremy suggested, I have since discovered that you can select all the tables and delete them from the context menu (brought up by a right click).

There's a truncate option too, if you just want to empty the tables.