You use DDL queries to modify the structure of a Microsoft Jet database. They can be used to build and delete tables, to add and delete fields and indexes from those tables, and to create referential integrity relationships between two tables.
The following is an example of a DDL QueryDef object that creates a new table with three fields and builds a primary key index on the Auto_ID field:
CREATE TABLE AUTOS (Auto_ID TEXT (10) CONSTRAINT PrimaryKey PRIMARY KEY, Make TEXT(20), Model TEXT(20));
See Also For specific types of and uses for Microsoft Jet DDL queries, see Chapter 3, “Data Definition and Integrity.”