Online Documentation for SQL Manager for DB2

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.

 

 

Creating Schemas

 

To create a new schema:

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:

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.

 

 

Editing Schemas

 

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.

 

Dropping Schemas

 

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.