Schema Manager allows you to add, edit and delete schemas within the diagram. To open Schema Manager, select the Diagram | Schema Manager menu item.
Schema is a virtual object of a diagram and has no graphical representation. After defining a schema, it appears in the object editors, so that you could attach other diagram objects to it.
Schema Manager contains a grid that represents schemas available in the diagram and their properties. The schema properties you can change in the grid are as follows:
The name of a schema to be created. The name cannot begin with pg_, as such names are reserved for system schemas.
Comment to the schema.
The name of the user who will own the schema. If omitted, defaults to the user executing the command. Only superusers may create schemas owned by users other than themselves.
Set this option off to disable generation of the schema during database generation.
This flag shows if the schema is system and can't be changed by a user.
The buttons below the list of schemas allow you to perform the following actions:
The Preview tab displays the SQL statement, which will be executed during the database generation. This statement is made up according to the changes you have made using the previous tabs. Please note that the text within the editor is read-only. The content of this tab updates only when your press the Apply button.