Data Source: Determining the Schema of the Data Source (ODBC)

  • Article

|  Overview |  How Do I |  FAQ |  Sample |  |  ODBC Driver List

This article applies to the MFC ODBC classes. For information about the MFC DAO classes, see the article Data Access Objects (DAO).

To set up data members in your CRecordset objects, you need to know the schema of the data source to which you are connecting. Determining the schema of a data source involves obtaining a list of the tables in the data source, a list of the columns in each table, the data type of each column, and the existence of any indexes.

To determine the schema of a data source

  • See the MFC Database samples and , which use the ODBC API functions ::SQLTables and ::SQLColumns.

See Also   Data Source (ODBC), Data Source: Managing Connections (ODBC)