Creates a new table.
Note The Microsoft Jet database engine does not support the use of CREATE TABLE, or any of the DDL statements, with non-Microsoft Jet database engine databases. Use the DAO Create methods instead.
Syntax
CREATE TABLE table (field1 type [(size)] [NOT NULL] [index1] [, field2 type [(size)] [NOT NULL] [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])
The CREATE TABLE statement has these parts:
Part | Description |
table | Name of the table to be created. |
field1, field2 | Name of field or fields to be created in the new table. You must create at least one field. |
type | Data type of field in the new table. |
size | Field size in characters (Text and Binary fields only). |
index1, index2 | CONSTRAINT clause defining a single-field index. See the CONSTRAINT clause topic for more information on how to create this index. |
multifieldindex | CONSTRAINT clause defining a multiple-field index. See the CONSTRAINT clause topic for more information on how to create this index. |
Remarks
Use the CREATE TABLE statement to define a new table and its fields and field constraints. If NOT NULL is specified for a field, then new records are required to have valid data in that field.
A CONSTRAINT clause establishes various restrictions on a field and can be used to establish the primary key. You can also use the CREATE INDEX statement to create a primary key or additional indexes on existing tables.
You can use NOT NULL on a single field or within a named CONSTRAINT clause that applies to either a single field or to a multiple-field named CONSTRAINT. However, you can apply the NOT NULL restriction only once to a field, or a run-time error occurs.