A schema is a collection of database objects, which might be:

• tables

• views

• file formats

In the SqlDBM tool, you can find a list of schemas in the "Database Explorer" panel and in "Database Documentation".

Pick a color for your schemas to quickly identify objects in that schema.

For instance, when you color Schema with orange, all tables in that schema become orange too. Vice versa, if you want to make the colors of schema objects the same, just click the "Inherit button" in the Schema properties.

By default schema name is represented near the table name on the canvas. Toggle the schema name on and off using the checkbox in Diagram properties.

In diagram explorer, you can find a similar option that toggles the visibility of the schema name in the object list.

You may choose schema for some objects in the object properties panel. This includes:

• tables

• views

• bulk properties

You can create a new schema in "Database Explorer" using:

• Context menu by schema tree

• Bottom bar when you choose schema tree

When reverse engineering a schema, its creation DDL is included along with the rest of the objects that belong to it. The exception to this are Oracle schemas, which are tied to the user account. Reverse Engineering an Oracle schema will not include schema DDL, but new schemas can be created and Forward Engineered.