Managing Schemas

To manage the schemas for the model version...

1. Right-click on the version, or on a white space in the diagram, and select Schemas>Manage schemas.

REPLACE WITH THIS IMAGE: Images/schemas/manageschema1.png

1. The following dialog enables you to manage the schemas for all the entities in this model version.

REPLACE WITH THIS IMAGE: Images/schemas/manageschema2.png

1. On the Schema Manager screen

   Icons	Definition
   REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png	Click to Add a new schema.
   REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png	Click to Edit a schema name.
   REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png	Click to Delete a schema
   Entities	Click to first filter on certain entities and then to use the check-boxes to select the relevant entities.
   Schemas	Click to move the already selected entities to a different schema, select the schema from the drop-down list and click the Move button

2. In this example, the following three entities have no schema assigned to them.

REPLACE WITH THIS IMAGE: Images/schemas/manageschema3.png
and the following two entities are assigned to schema dbo.
REPLACE WITH THIS IMAGE: Images/schemas/manageschema4.png