Working with Schema |
A schema is essentially a namespace. A schema contains schema objects, also known as named objects. Tables, views, indexes, synonyms, domains, commands and procedures are all examples of schema objects. Synonyms and domains must have unique names in the database, but other schema object names may duplicate those of other objects existing in other schemas. Schema objects are accessed by qualifying their names. Qualifying a schema object means tagging the object with the schema¡¦s name as a prefix.
You can quickly and easily, enter or remove, a schema into the current database using the JTool interface. The schema name must be distinct from the name of any existing schema in the current database.
Related topic:
Browsing Shema
Creating a Schema
Dropping a Schema