A schema is a collection of named objects. It provides a logical classification of objects in the database and may contain objects such as aliases, tables, views, indexes, triggers, distinct types, functions, and packages.
You can explicitly create a schema using the Create Schema window. One can be implicitly created when an object (such as an alias, table, view, index, trigger, or package) is created. The schema exists in the database as an object.
When creating an object, you can assign it to a schema by specifying the schema name. The schema name is used as the first-part of the two-part object name. If a schema name is not specified then the authorization name of the creator of the object will be used as the default.
[ Top of Page | Table of Contents | Glossary | Index ]