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
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
The CREATE statement
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The CREATE
statement is the most important DDL statement. It allows for creating new objects in the database catalog.
Table of contents
- 4.6.3.1.
- CREATE DATABASE
- 4.6.3.2.
- CREATE DOMAIN
- 4.6.3.3.
- CREATE FUNCTION
- 4.6.3.3.1.
- Scalar functions
- 4.6.3.3.2.
- CREATE OR REPLACE FUNCTION
- 4.6.3.3.3.
- SQL data access characteristics
- 4.6.3.3.4.
- DETERMINISTIC characteristic
- 4.6.3.3.5.
- ON NULL INPUT characteristic
- 4.6.3.4.
- CREATE INDEX
- 4.6.3.5.
- CREATE PROCEDURE
- 4.6.3.5.1.
- CREATE OR REPLACE PROCEDURE
- 4.6.3.5.2.
- SQL data access characteristics
- 4.6.3.6.
- CREATE SCHEMA
- 4.6.3.7.
- CREATE SEQUENCE
- 4.6.3.8.
- CREATE TABLE
- 4.6.3.8.1.
- Columns
- 4.6.3.8.2.
- Nullability
- 4.6.3.8.3.
- Defaults
- 4.6.3.8.4.
- Identities
- 4.6.3.8.5.
- Computed columns
- 4.6.3.8.6.
- Primary key
- 4.6.3.8.7.
- Unique constraints
- 4.6.3.8.8.
- Foreign keys
- 4.6.3.8.9.
- Check constraints
- 4.6.3.8.10.
- From a SELECT
- 4.6.3.8.11.
- Temporary tables
- 4.6.3.9.
- CREATE TRIGGER
- 4.6.3.9.1.
- Events
- 4.6.3.9.2.
- REFERENCING clause
- 4.6.3.9.3.
- STATEMENT vs ROW triggers
- 4.6.3.9.4.
- WHEN clause
- 4.6.3.10.
- CREATE TYPE .. AS ENUM
- 4.6.3.11.
- CREATE TYPE .. AS OBJECT (new)
- 4.6.3.12.
- CREATE VIEW
- 4.6.3.12.1.
- OR REPLACE
- 4.6.3.12.2.
- WITH CHECK OPTION
- 4.6.3.12.3.
- WITH READ ONLY
- 4.6.3.12.4.
- MATERIALIZED (new)
previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!