How to empty an existing database?

4,465 views
Skip to first unread message

Simon Sturmer

unread,
Aug 1, 2012, 12:00:40 AM8/1/12
to seque...@googlegroups.com
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

unread,
Aug 1, 2012, 3:43:37 AM8/1/12
to seque...@googlegroups.com
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

unread,
Sep 3, 2014, 6:47:18 AM9/3/14
to seque...@googlegroups.com
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.


Reply all
Reply to author
Forward
0 new messages