Creating and Editing Schemas


The following procedures describe how to create and edit database schemas.

Creating a Schema:

In Database Explorer right click on the Schemas node.

In the popup menu that appears, click Add Schema. In the dialog box that appears, enter a name for the schema. A comment can be specifed too. Click Ok to add the schema.

Editing a Schema:

In Database Explorer, click on the Schemas node.

A grid of this database's schemas will be shown in the lower right.

You can type directly into this grid to modify a schema's name and/or comment .

Deleting a Schema:

In Database Explorer, click on the Schemas node.

In the Schemas grid in the lower right, select the rows representing the schemas to delete. Click the Remove button.


See also:

Transferring Schema Objects