Creating SQL Procedures to Run Before and After Generating a Physical Model View

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 view 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 View Editor can be included in the SQL generated before and after the CREATE VIEW statement that creates the view.

  1. Double-click a view to which you want to associate an SQL procedure.
  2. In the View 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