To manage the schemas for the model version...
- 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
- 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
- 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
- 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