The ADOXCE object model allows the objects in a database (such as tables and columns) to be added, modified, and deleted. You can also use SQL statements to do the same, which can often be more convenient and quicker. These SQL statements are called "Data Definition Language," or DDL, statements. SQL statements that manipulate data are called "Data Manipulate Language," or DML, statements. The following DDL statements are supported:
The CREATE TABLE statement allows a table to be created by giving a name for the new table and the list of columns (fields) and their data types. The allowable data types for Microsoft ...