Toad World® Forums

Generate delete script


#1

Can I somehow generate a delete script for the whole model?
I like to drop all table in my database to be able to re-run a newer DDL script.

Andreas


#2

Hello,

Yes, it is possible. You have to modify the blue arrows.

Example movie:
http://modeling.inside.quest.com/entry.jspa?externalID=1679&categoryID=158

See also:
http://modeling.inside.quest.com/kbcategory.jspa?categoryID=159

Regards,

Vladka


#3

Helpful example, but I’d like to drop the whole database.

So I created an empty model and played with the blue arrows in the Converter and finally really generated a drop script for the whole model.

Thanx for your hints.

Andreas


#4

Another option:
Press F9 to open the Script Generation dialog | What to Generate tab | expand the nodes | see the column Extended Value and select Drop for the items that you want to drop and clear boxes for items you do not want to generate.
Click Generate and then Show Code.

Regards,

Vladka

Message was edited by: vladka


#5

Thanx for the hint.

Andreas