Working with Data Models › Forward Engineer/Alter Script › Forward and Reverse-Engineering Physical Storage Objects

Forward and Reverse-Engineering Physical Storage Objects

When you generate the physical database schema from a physical model, you can include your defined physical storage objects as part of the schema. The physical object definitions are translated into the appropriate SQL CREATE statements and the specified parameters are inserted in the correct syntax. When you forward-engineer a model, the parent storage objects are created first. The child storage objects and physical tables are created later in the specified storage location.

When you reverse-engineer a database, you can import the names and definitions of physical storage objects you have defined on the target server. The import happens in the same way that physical tables, indexes, and other physical schema information is imported. After you import physical storage objects, you can view or modify the object definitions and table associations using the standard editors.