Understanding Tables Used by IDOs

Although there are many aspects of IDOs that do not correspond directly to tables in a SQL Server relational database, SQL Server tables provide the foundation on which any IDO is built.

  • All tables used by IDOs must have certain required columns and triggers.
  • Each IDO must have at least one base table.
  • To include read-only information from associated tables in an IDO, use secondary tables.
  • For most IDOs, primary key properties used by the base table in the application database are detected automatically. However, primary key properties for IDOs based on a SQL View must be specified manually. To identify the primary key properties and their sort order, set the IDO's advanced attributes.