Toad data modeler for sql server
There are several methods how to specify a list of the generated objects. On the last tab, select list, define instances of objects. In other words, if you generate SQL code just for the one selected workspace, both the tables must be members of that workspace. On this tab, you can define if referential integrity code should be generated only if both the tables are generated. On tab Referential Integrity, specify rules for a referential integrated generation. Select appropriate option and click OK to confirm changes. To change the values, select the item in the grid and press F2 key to enable combo box with available options. On the same form, you can specify how keys, indexes and some other supported objects should be generated. And use the green arrow icons on the toolbar to change the order.
Select items you wish to move up or down. In case you need to change the order of generated objects- for example, if you know that some function should be generated before stored procedure creation statements- click the Edit button. You can use quotation marks, create indexes to foreign keys, and so on. On tab Detail Settings, specify advanced options that are available for the selected target database- in this case, for Oracle 10g. You can set the values one by one or use the combo box above to create. And select Drop, Create, or Drop and Create type of SQL statements. Select what object types you wish to generate. If you need to generate SQL code for a specific schema, select the appropriate item in the user schema combo box. On what to generate, specify path to the output file. How to generate SQL code- press F9 key or click the Generate DDL Script icon on toolbar. Each workspace contains a different number of tables, views, and other objects. It's a relatively small model with several workspaces.
In this demonstration, I will use the video rental sample model. Today, I'm going to show you how to generate SQL code for your models. And welcome to this presentation on Toad Data Modeler Version 5.