CREATE TABLE

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

Arguably the most used DDL statement is the CREATE TABLE statement.

The following subsections discuss various usages of CREATE TABLE, as well as the relevant bits of meta data that can be added to a table.

Table of contents

3.4.3.6.1.

Columns

3.4.3.6.2.

Nullability

3.4.3.6.3.

Defaults

3.4.3.6.4.

Identities

3.4.3.6.5.

Primary key

3.4.3.6.6.

Unique constraints

3.4.3.6.7.

Foreign keys

3.4.3.6.8.

Check constraints

3.4.3.6.9.

From a SELECT

3.4.3.6.10.

Temporary tables