Available in versions: Dev (3.16) | Latest (3.15) | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | 3.7

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.4.3.1.
CREATE DATABASE
4.4.3.2.
CREATE DOMAIN
4.4.3.3.
CREATE FUNCTION (new)
4.4.3.3.1.
Scalar functions (new)
4.4.3.3.2.
CREATE OR REPLACE FUNCTION (new)
4.4.3.3.3.
SQL data access characteristics (new)
4.4.3.3.4.
DETERMINISTIC characteristic (new)
4.4.3.3.5.
ON NULL INPUT characteristic (new)
4.4.3.4.
CREATE INDEX
4.4.3.5.
CREATE PROCEDURE (new)
4.4.3.5.1.
CREATE OR REPLACE PROCEDURE (new)
4.4.3.5.2.
SQL data access characteristics (new)
4.4.3.6.
CREATE SCHEMA
4.4.3.7.
CREATE SEQUENCE
4.4.3.8.
CREATE TABLE
4.4.3.9.
CREATE TRIGGER (new)
4.4.3.9.1.
Events (new)
4.4.3.9.2.
REFERENCING clause (new)
4.4.3.9.3.
STATEMENT vs ROW triggers (new)
4.4.3.9.4.
WHEN clause (new)
4.4.3.10.
CREATE TYPE
4.4.3.11.
CREATE VIEW

The jOOQ User Manual : SQL building : SQL Statements (DDL) : The CREATE statementprevious : next

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo