Database Definition and Manipulation

  • Article

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

The MFC DAO classes support two kinds of access to databases:

  • Data definition language (DDL)   You can create and delete databases, create and delete tables, define table fields and indexes, and take other actions that affect the structure of your database.

  • Data manipulation language (DML)   You can run queries, add, delete, and edit records, and otherwise manipulate the content of your database.

The MFC ODBC classes support only DML, but you can call ODBC API functions directly to carry out DDL tasks.