Schema (Data Access)

A database schema describes the current structure of the tables and database views in the database. In general, wizard-generated code assumes that the schema for the table or tables accessed by a recordset will not change, but the database classes can deal with some schema changes, such as adding, reordering, or deleting unbound columns. If a table changes, you must manually update the recordset for the table, then recompile your application.

You can also supplement the wizard-generated code to deal with a database whose schema is not entirely known at compile time. For more information, see Recordset: Dynamically Binding Data Columns (ODBC).

See Also

Concepts

Data Access Programming

SQL

Recordset (ODBC)