CREATE TABLE

Use the CREATE TABLE statement to create a new table in the database. Its syntax is:

	CREATE TABLE table (
		field1 type [(size)] [index1] 
		[, field2 type [(size)] [index2] 
		[, ...]] 
		[, multifieldindex [, ...]]
	)

The parts of this statement have the folowing meaning:

Part Meaning

table The name of the table to be created.

fieldn The columns to be included in the new table

type The datatype of the particular column

indexn An index on the particular column, expressed as a CONSTRAINT clause.

Multifieldindex An index on more than one field, e.g. a compound primary key, expressed as a CONSTRAINT clause.

[Return to SQL Syntax]

Part	Meaning
table	The name of the table to be created.
fieldn	The columns to be included in the new table
type	The datatype of the particular column
indexn	An index on the particular column, expressed as a CONSTRAINT clause.
Multifieldindex	An index on more than one field, e.g. a compound primary key, expressed as a CONSTRAINT clause.