Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
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.4.3.1.
- CREATE INDEX
- 3.4.3.2.
- CREATE SCHEMA
- 3.4.3.3.
- CREATE SEQUENCE
- 3.4.3.3.1.
- CREATE SEQUENCE IF NOT EXISTS
- 3.4.3.4.
- CREATE TABLE
- 3.4.3.4.1.
- Columns
- 3.4.3.4.2.
- Nullability
- 3.4.3.4.3.
- Defaults
- 3.4.3.4.4.
- Identities
- 3.4.3.4.5.
- Primary key
- 3.4.3.4.6.
- Unique constraints
- 3.4.3.4.7.
- Foreign keys
- 3.4.3.4.8.
- Check constraints
- 3.4.3.4.9.
- From a SELECT
- 3.4.3.4.10.
- Temporary tables
- 3.4.3.5.
- CREATE TYPE (new)
- 3.4.3.6.
- CREATE VIEW
- 3.4.3.6.1.
- CREATE OR REPLACE VIEW
- 3.4.3.6.2.
- WITH CHECK OPTION
- 3.4.3.6.3.
- WITH READ ONLY
previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!