Catalog Information

HomeOverviewHow Do IFAQ   |  ODBC Driver List

Information about the tables in a data source can include the names of tables and the columns in them, table privileges, names of primary and foreign keys, information about predefined queries or stored procedures, information about indexes on tables, and statistics about tables.

See the article Data Source: Determining the Schema of the Data Source (ODBC).

See also information about the ODBC “catalog functions” in the ODBC SDK Programmer’s Reference and the MFC Database sample program CATALOG.

Note   In the MFC DAO classes, you can get catalog information as follows: Use CDaoDatabase::GetTableDefCount and CDaoDatabase::GetTableDefInfo to enumerate the tables in the database and obtain information for each table in a CDaoTableDefInfo structure. For more information, see the article DAO Collections: Obtaining Information About DAO Objects.