Feature Request: Drop Scripts

[frankbryce]

I think an excellent addition to this tool would be to have a script to drop table(s) in the database, including the related dependencies such as triggers, foreign keys, etc. Do you think this is in the cards to do in the future?

[sethreno]

I use shcemazen to keep dbs in version control. So I typically script and entire db then recreate it from source for testing. In my use case I don't have a need for this feature as the entire database is dropped and recreated.

There's also the (experimental) compare feature that can be used to generate deployment scripts. Can you explain a little bit about how you're using schemazen and where this feature fits in? Is it related to the compare feature?

[kdd21]

We're using it temporarily to replicate some objects out of one database and into another. We've been able to make it work, but we'd REALLY like it if it was possible to tell it to NOT drop the database first, so that we could use it to add objects to an existing database. We've wrappered it with a lot of bat script logic to remove stuff after export, but it's clumsy to say the least.