Next Previous Up Top Contents Index

1 The SQL-ODBC Library

1.8 Database introspection

The SQL-ODBC library offers introspection features to allow you to determine the structure of a database at run time. A database structure is a hierarchy comprising catalogs, schemas, tables and columns. A catalog is a named collection of schemas, a schema is a named collection of tables, and a table is a named collection of columns. For security reasons, the SQL-ODBC library does not provide any means of obtaining a list of databases available from a particular DBMS; your application must provide access to a particular database via a connection object.

For DBMSes which do not support catalogs or schemas, the SQL-ODBC library uses a default value that your application can use to perform introspection.

1.8.1 - Database objects and integrity constraints
<database-object>
database-object-name
1.8.2 - Catalogs
<catalog>
catalogs
1.8.3 - Schema
<schema>
1.8.4 - Tables
<sql-table>
indexes
1.8.5 - Columns
<column>
domain
nullable?
default-value
1.8.6 - Indexes
<index>
indexed-table
fields
unique-index?

OLE, COM, ActiveX and DBMS Reference - 31 MAR 2000

Next Previous Up Top Contents Index