Defining Views in an Information Model
Before you can generate a view, you must add view definitions to your information model using IViewClassDef, IViewInterfaceDef, or IViewRelationshipDef.
You must set at least one of the following flags to cause view generation: GENERATE_RESOLVED_VIEW, GENERATE_NORESOLUTION_VIEW, or GENERATE_WORKSPACE_VIEW. Each one of these flags generates a different kind of view.
You can add view definitions using the Model Development Kit (MDK) or the repository API. The following topics describe the kinds of SQL views you can generate.
Topic | Description |
---|---|
Kinds of SQL Views | Describes the scope and attributes of generated views. |
Defining a Class View | Provides information about SQL views that are based on a class. |
Defining an Interface View | Provides information about SQL views that are based on an interface. |
Defining a Junction Table View | Provides information about SQL views that are based on a relationship class. |
Defining View Columns | Provides information about customizing a view column. |
MDC OIM SQL Views
The Meta Data Coalition (MDC) Open Information Model (OIM) is distributed with predefined SQL views that are ready to use. These views are added to the views folder of your Microsoft® SQL Server™ 2000 repository database when the MDC OIM is installed.