Defining Schema Properties

Define schema details in the properties sheet.

Prerequisites

Add the schema definition to the ESPSchema model.

Task

Open the ESP Schema Properties sheet from the Browser tree or the diagram.
Edit fields on the General, Attributes, and Identifiers tabs.
(Optional) Right-click an attribute to open the Attribute Properties sheet.
(Optional) In the Attribute Properties sheet, choose More to see extended property details.
Choose Apply to apply changes.
Choose OK when done.

General Tab Properties
View information about the Name, and Comment properties of a schema definition on the General tab of the Schema Definition Properties sheet.
Attributes Tab Properties
The Attributes tab of the Schema Definition Properties sheet lets you quickly set information for all fields of an ESP Schema.
Adding an Attribute to Schema
Add fields to schema by adding attributes to the schema definition.
Identifiers
An identifier is a column or combination of columns that uniquely defines a specific ESP Schema.
Defining Identifiers
Define identifiers to indicate which schema attributes become keys in the destination table.

Parent topic: Creating an ESP Schema Model