Creating and Editing PreSQL and PostSQL for the CREATE TABLE Statement

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

Go Up to Creating and Editing SQL Procedures

In the PreSQL & PostSQL tab of the Table Editor you can enter SQL procedures to be applied before and after the CREATE TABLE statement.

  • The SQL in the procedure will be validated in context of the table selected and the database platform.
  1. In the Data Model Window or Data Model Explorer, double-click a table to launch the Table Editor.
  2. Click the PreSQL & PostSQL tab.
  3. Enter or edit an SQL procedure to run before the CREATE TABLE statement.
  4. Click the PostSQL tab and then enter or edit an SQL procedures to run before the CREATE TABLE statement.
  5. Click OK to implement the changes and exit the editor.

See Also