The jOOQ User Manual : SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TABLE | previous : next |
Available in versions: Dev (3.17) | Latest (3.16) | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | 3.7
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
The jOOQ User Manual : SQL building : SQL Statements (DDL) : The CREATE statement : CREATE TABLE | previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!