Export (0) Print
Expand All

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

This article applies to the MFC ODBC classes. For information about the MFC DAO classes, see the article Overview: 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 CATALOG and DYNABIND, which use the ODBC API functions ::SQLTables and ::SQLColumns.

See Also

Data Source (ODBC) | Data Source (ODBC) | Data Source: Managing Connections (ODBC)

© 2014 Microsoft