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.
Related topics