1. Home
  2. Docs
  3. Chapter 14. Database Design & Engineering
  4. 2. Database Designer’s Guide
  5. Applying default schema on ERD

Applying default schema on ERD

Download PDF

A default schema can be set on diagram. Entities to be created on the diagram will all share the same schema. To define a default schema on ERD :

  1. Right click on the diagram background and select Open Specification… from the pop-up menu.
  2. Enter the default schema in the Entity Relationship Diagram Specification window.
    Entering default schema
  3. Click OK to confirm the change. Now, when you create an entity on the diagram, the entity will be under the default schema.
    An entity with myschema as its schema

In order to move existing entities in an ERD to a schema, define default schema on the Entity Relationship Diagram first, then right click on the diagram and select Apply Default Schema from the pop-up menu. This will make all entities that have master view on the diagram to move to the schema defined.