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 INDEX

4.4.3.2.

CREATE SCHEMA

4.4.3.3.

CREATE SEQUENCE

4.4.3.4.

CREATE TABLE

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

4.4.3.5.

CREATE VIEW

4.4.3.5.1.

OR REPLACE (new)

4.4.3.5.2.

WITH CHECK OPTION

4.4.3.5.3.

WITH READ ONLY