Schemas
A Schema is essentially a namespace: it can be defined as a collection of database objects that form a single namespace. A namespace is a set in which each element has a unique name.
To create a new schema:
- select the Database | New Object... main menu item;
- select Schema in the Create New Object dialog;
- define schema properties using the appropriate tabs of Schema Editor.
Hint: To create a new schema, you can also right-click the Schemas node or any object within this node in the DB Explorer tree and select the New Schema item from the context menu.
To create a new schema with the same properties as one of existing schemas has:
- select the Database | Duplicate Object... main menu item;
- follow the instructions of Duplicate Object Wizard.
Alternatively, you can right-click a schema in the DB Explorer tree and select the Duplicate Schema <schema_name>... context menu item.
Duplicate Object Wizard allows you to select the database to create a new schema in, and to edit the result SQL statement for creating the schema.
To edit an existing schema:
- select the schema for editing in the DB Explorer tree (type the first letters of the schema name for quick search);
- right-click the object and select the Edit Schema <schema_name>... context menu item, or simply double-click the schema;
- edit schema properties using the appropriate tabs of Schema Editor.
To drop a schema:
- select the schema to drop in the DB Explorer tree;
- right-click the object and select the Drop Schema <schema_name>... context menu item;
- confirm dropping in the dialog window.
Note: If more convenient, you can also use the following shortcuts:
Ctrl+N to create a new schema;
Ctrl+O to edit the selected schema;
Shift+Del to drop the object from the database.