How to Add a Pre or Post-script to Table Creation Statements in Forward Engineering (4344085)

Description:

How to add a Pre- Post Script t Table creation?

Solution:

Steps:

To add a Pre or Post-Script to a Table….

• Navigate to Model --> Script Templates

• A new window will open. Click the new button

• Enter your Pre or Post Script by….
  1. Giving it a name
  2. Specifying Type as Table Level
  3. Indicating if it is a Pre or Post Script in the “Generate As” field
  4. (Optional) By selecting “Attach to New”, you can automatically attach this to newly created Tables
  5. Ensure that “Generate” is selected so that the script is included when Forward Engineering
  6. Entering the SQL for your Pre or Post Script under the “Code” tab
  7. Click “Close”

• Attach your Pre or Post script to existing Tables by…
  • Right click on the table and select “Table Properties" 
  • Under the “Object Creation Order” tab select “Script Templates” for Display
  • Check the desired script and click “Close”
• Then Forward Engineer your Table by selecting Actions --> Forward Engineer --> Schema

• In the resulting dialogue under “Option Selection” and “Table”, ensure Pre and / or Post-script are selected (Pre will generate before the other code is generated whereas Post will create it after code is created).

• Preview the results…