Are DDL and DML Supported?


The latest version of this topic can be found at Visual Studio 2017 Documentation. 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.

See Also

Data Access Frequently Asked Questions