Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9
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
- 4.4.3.4.1.
- Columns
- 4.4.3.4.2.
- Nullability
- 4.4.3.4.3.
- Defaults
- 4.4.3.4.4.
- Identities
- 4.4.3.4.5.
- Primary key
- 4.4.3.4.6.
- Unique constraints
- 4.4.3.4.7.
- Foreign keys
- 4.4.3.4.8.
- Check constraints
- 4.4.3.4.9.
- From a SELECT
- 4.4.3.4.10.
- Temporary tables
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!