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

3.6.3.1.

CREATE DATABASE

3.6.3.2.

CREATE DOMAIN

3.6.3.3.

CREATE FUNCTION

3.6.3.3.1.

Scalar functions

3.6.3.3.2.

CREATE OR REPLACE FUNCTION

3.6.3.3.3.

SQL data access characteristics

3.6.3.3.4.

DETERMINISTIC characteristic

3.6.3.3.5.

ON NULL INPUT characteristic

3.6.3.4.

CREATE INDEX

3.6.3.5.

CREATE PROCEDURE

3.6.3.5.1.

CREATE OR REPLACE PROCEDURE

3.6.3.5.2.

SQL data access characteristics

3.6.3.6.

CREATE SCHEMA

3.6.3.7.

CREATE SEQUENCE

3.6.3.7.1.

CREATE SEQUENCE IF NOT EXISTS

3.6.3.7.2.

CREATE SEQUENCE .. CACHE

3.6.3.7.3.

CREATE SEQUENCE .. CYCLE

3.6.3.7.4.

CREATE SEQUENCE .. MINVALUE

3.6.3.7.5.

CREATE SEQUENCE .. MAXVALUE

3.6.3.7.6.

CREATE SEQUENCE .. INCREMENT BY

3.6.3.7.7.

CREATE SEQUENCE .. START WITH

3.6.3.8.

CREATE TABLE

3.6.3.8.1.

Columns

3.6.3.8.2.

Nullability

3.6.3.8.3.

Defaults

3.6.3.8.4.

Identities

3.6.3.8.5.

Computed columns

3.6.3.8.6.

Primary key

3.6.3.8.7.

Unique constraints

3.6.3.8.8.

Foreign keys

3.6.3.8.9.

Check constraints

3.6.3.8.10.

From a SELECT

3.6.3.8.11.

Temporary tables

3.6.3.9.

CREATE TRIGGER

3.6.3.9.1.

Events

3.6.3.9.2.

REFERENCING clause

3.6.3.9.3.

STATEMENT vs ROW triggers

3.6.3.9.4.

WHEN clause

3.6.3.10.

CREATE TYPE .. AS ENUM

3.6.3.11.

CREATE TYPE .. AS OBJECT (new)

3.6.3.12.

CREATE VIEW

3.6.3.12.1.

CREATE OR REPLACE VIEW

3.6.3.12.2.

WITH CHECK OPTION

3.6.3.12.3.

WITH READ ONLY

3.6.3.12.4.

MATERIALIZED (new)