SQL tables are used by the repository to store the instance information for tool information models. SQL schema modifications are automatically performed when you create or extend a tool information model.
Normally, one table is created for each interface that is defined in the repository. The table contains the instance data for persistent properties that are attached to the interface. One column in the table is created for each property. If an interface is defined that has no member properties, a table is not created.
You can construct a SQL query to extract specific tool information from the repository. You need to be familiar with the SQL schema for a tool information model to build such a query.
The MDO Model is a tool information model, and therefore, its instance information is stored in SQL tables. In the MDO Model (without any extensions), there are only two interfaces that have member properties: the IMdoModelItem interface and the IMdoControl interface. The SQL table names for these two interfaces are shown below.
| Interface | SQL Table Name |
| IMdoControl | TblMdoControl |
| IMdoModelItem | TblMdoModelItem |