Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server Property Editors › Common Property Pages › Define Script Templates (Pre and Post Scripts)
Define Script Templates (Pre and Post Scripts)
You can use the Script Template Editor to create or modify script templates when you are working in a physical model, with any of the supported target databases defined as the target server.
To define script templates
- Click Pre & Post Scripts on the Database menu.
The Script Template Editor opens.
- Select a script template and work with the following options:
Note: Click New 
on the toolbar to create a script template.
- Name
-
Specifies the name of the script template. Change the name of the script template in this field.
- Type
-
Specifies to generate the script template for a model or a table.
- Generate As
-
Specifies to generate the script template pre-creation or post-creation.
- Attach to New
-
Specifies if you want to attach this script to all new (table-level only) tables.
- Generate
-
Specifies whether or not to generate DDL for this object during Forward Engineering. If you do not select the check box, DDL will not be generated for this object during Forward Engineering.
- Review or assign code to the script template on the Code tab. Use the options on the Code tab toolbar to work with your text. Click the Macro Toolbox
icon to insert a pre-configured macro.
- Work with the other tabs in the editor to access additional features, for example:
- (Optional) Click the Comment tab and enter any comments you want associated with the script.
- (Optional) Click the UDP tab to work with user-defined properties for the script.
- Click Close.
Your changes are saved and the Script Template Editor closes.
More information:
SQL Server Browser for Functions, Script Templates, and Stored Procedures
View Expanded Code in a Property Editor
Add a Comment in a Property Editor
Add a UDP in a Physical Property Editor
Copyright © 2017 erwin Inc.
All rights reserved.
|
|