A schema defines the logical structure of the database that contains your data tables. By default, Connect includes four different schemas that serve most users’ needs: delta, xactly, xdms, and staging. (For definitions, see Show Schemas.)

To create a new schema, use CREATE:

1 SQL> create schema playground;

Check that our new schema has been added:

1 SQL> show schemas;

NOTE: While Connect allows you to create custom schemas, we recommend sticking to the four default schemas, and using the delta schema for custom tables.