Toad World® Forums

Tables ONLY then triggers ONLY DDL script generation - HELP needed


#1

Hi,

How to setup “Generate DDL Script” to:

  • generate ONLY tables (entities) without triggers (I want to save this as ONLY_TABLES selection)
  • generate ONLY triggers without tables generation (I want to save this as ONLY_TRIGGERS selection) ?

When I select on “DDL Script Generation of …” window to generate Triggers only IT generates Tables too :-(((

Please Help,

Best regards,

Adam

FYI:
Toad Data Modeler:

  • File Version: 3.3.7.22
  • Licence Number: XXX-XXXXX
  • Licence Type: Permanent
    Remaining Days: n/a
    Expires On: n/a

Model:
Database: Db2 v.9 (LUW)


#2

Hi Adam,

It is possible to generate tables only - without triggers, however, it is not possible to generate triggers without tables. This relates to all items that are within or “under” entities.

Unfortunately, there is no workaround or temporary solution for this. We will deal with this issue - it’s already been requested in CR # 46 975.

Thanks for your patience.

Regards,

Vladka


#3

Hi Adam again,

I missed the most important point - write how to generate only the tables… :wink: Sorry.

So, simply select only the Entities checkbox in the Script Generation dialog | What to Generate tab. See the sub-items of the Entity and feel free to clear them.

You can save this OTP setting - please see how to do it in this flash movie (Expert Mode has to be turned on):
http://modeling.inside.quest.com/entry.jspa?externalID=1695&categoryID=281

If you have ANY questions, please write me back. Thanks.

Regards,

Vladka