Define a schema

Define a schema to organize the tables and other data objects by using the New Schema Definition wizard. A schema is a collection of named objects. In relational database technology, schemas provide a logical classification of objects in the database. Some of the objects that a schema might contain include tables, views, aliases, indexes, triggers, and structured types. Define schemas to organize the tables and other data objects

Prerequisite: Before you define a schema, create a database.

To define a schema:

1. Switch to the Data Definition view in the Data perspective.

2. Right click a database, and click New > Schema Definition. The New Schema Definition wizard opens.

3. In the Schema name field, type the name of the schema that you want to create. Limitation: Schema identifiers that contain a period (.) character, for example, my.schema, are not supported. The period can be used to create a qualified identifier, for example, myschema.mytable.

4. Click Finish. The schema is added to the database folder.

5. Expand the schema to display the folders underneath it. You can use these folders to add other data objects such as tables.

 

Parent topic

Defining database objects