Creating Tables by Using SQL DDL

Even the most basic TableDef object in a Microsoft Jet database must contain at least one field. It’s not necessary to specify a primary key, validation rules, or any of the other optional properties such as Description or DefaultValue. The table is nothing without its fields.

Using SQL DDL statements, the simplest statement you can use to create a new table in a database is as follows:

CREATE TABLE MyTable (MyField TEXT);

The CREATE TABLE statement creates a table called MyTable with one field called MyField. MyField is built as a variable-length text field with a maximum length of 255 characters. The field is not required, and may contain Null values. It’s not indexed.