Adding Foreign Keys

Add foreign-key relationships to physical data models.

  1. Add tables to the physical data model that are not in your Market Data diagram and that contain lookup columns for foreign keys.

    New ASE, SAP HANA, and SAP Sybase IQ models generated from a ESP Schema model contain only market data tables.

  2. Right-click the table and choose Properties or Keys.
  3. Add foreign-key relationships to tables that are not in the Market Data diagram.
Parent topic: Generating a new Sybase IQ, SAP HANA, or ASE Model from an ESP Schema Model