Toad World® Forums

Add option to add drop statement in script window


Currently when you open the script window it shows your create statement as well as your setting your schema and user name.

I was wondering if you could add an option in the settings to add the drop statement before the create in the script window?

Since z/OS does not really allow for alter of store procedures I think having an option to enable the script window to auto put drop statement would be handy since I always have to drop and re-create objects.

Thanks again!

Toad for DB2 Beta (64 bit). Db2 for z/OS.

The Script tab is meant to be a quick\simple means of displaying the creation DDL.

We do not want to introduce complexity to that control.

You can use the 'Extract DDL' feature to optionally generate DROP statements along with creation DDL.