Creating SQL Procedures to Run Before and After Generating a Table

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Using ER/Studio Data Architect

You can create PreSQL and PostSQL that ER/Studio Data Architect runs before generating a table in the physical model when you choose the Database > Generate Database command and then click Finish in the wizard. The PreSQL and PostSQL you enter in the Table Editor can be included in the SQL generated before and after the CREATE TABLE statement that creates the table.

  1. Double-click the table you want to associate the SQL procedure with.
  2. In the Table Editor, click the PreSQL & PostSQL tab.
  3. Enter or copy and paste the PreSQL and PostSQL onto their respective tabs.
  4. If you want the PreSQL and PostSQL scripts to be generated, select Generate.
  5. Click OK.

See Also