Schemas
The Schemas tab of the SQL Metadata Tool allows you to create and modify a schema or a self-schema.
Ordinary users can create a self-schemas with the name
self_[USERNAME] as long as they
have add_self_schema privileges. Self-schema privileges allow you
to create schemas without requesting an administrator to create each schema. Once
the user creates a self-schema, it is no different in functionality from any other
schema. Check with your administrator if you need add_self_schema
privileges. Generally, only administrators should have add_schema
privileges.
- Schema name
- The name of the schema or self-schema in which your tables reside. Select an existing schema from the drop-down list, or enter a new schema name and click New.
The following options are available once you select a schema.
- Description
- An optional description of the schema.
- Users
- The authorized users of the schema. The current user ID is added by default.
- Admins
- The administrators of the schema. Admins can modify and delete the schema. The current user ID is added by default.
- Save changes to this schema
- This button appears when you have made changes to your schema. Click to save your changes.
- Abandon changes
- This button appears when you have made changes to your schema. Click to abandon your changes.
- Drop this schema
- Click to delete the selected schema. You must have
drop_schemaordrop_self_schema(if it is a personal schema) privileges.