|
|
|
A schema is a collection of any of the following database objects:
Each user can have only one schema consisting of definitions of the above types of database objects that the user owns. The database objects belong to the specific schema.
By default, the current user's schema is always assumed.
|
|
|
In VDBA, a schema is created for you automatically, and objects that you create are added to your schema. View the contents of your schema using the Schemas branch for a particular database in the Database Object Manager window.
If you are not using VDBA, manage schemas directly using the SQL statement, create schema. This statement allows you to create a schema, create the tables and views in that schema, and grant appropriate permissions as a unit. For more information on using this statement, see the SQL Reference Guide.
Various SQL statements allow you to specify a schema name to indicate a table or view belonging to a schema other than the one associated with the current user, as described in the SQL Reference Guide.