[sqlalchemy] drop all keys, indexes, permissions, views, etc.

2010-04-14 Thread Gerry Reno
I would like to be able to drop all foreign keys, then drop all indexes, drop all permissions, drop all views then drop all tables. I went looking for methods like DropForeignKeys, DropView, DropPermissions but there are no such method names. How can I perform all these actions in a batch

Re: [sqlalchemy] drop all keys, indexes, permissions, views, etc.

2010-04-14 Thread Michael Bayer
dropping tables implicitly drops indexes and foreign keys.For views we have a recipe at http://www.sqlalchemy.org/trac/wiki/UsageRecipes/Views . For permissions, those vary wildly across backends and we have no support for that built in, however you can again roll that yourself using the