Are DDL and DML Supported?

The new home for Visual Studio documentation is Visual Studio 2017 Documentation on docs.microsoft.com.

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.

Data Access Frequently Asked Questions