Data Definition Language

EdgeQL includes a set of commands to manipulate all aspects of the database schema. It is called the data definition language or DDL, and is a low-level equivalent to EdgeDB schema definition language.

In DDL the order of the commands matters, so if one type refers to another, the other type has to be created first. For example:

db> 
... 
... 
... 
CREATE TYPE Person {
    CREATE REQUIRED PROPERTY first_name -> str;
    CREATE REQUIRED PROPERTY last_name -> str;
};
CREATE
db> 
... 
... 
... 
... 
... 
... 
CREATE TYPE Movie {
    CREATE REQUIRED PROPERTY title -> str;
    # the year of release
    CREATE PROPERTY year -> int64;
    CREATE REQUIRED LINK director -> Person;
    CREATE MULTI LINK cast -> Person;
};
CREATE