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.