ASA Maestro online Help
Schemas
A schema is a collection of tables and views along with their associated permissions. To create a schema, the userid must be the user ID of the current connection. You cannot create a schema for another user.
Schemas are edited within Schema Editor. In order to run the editor you should either
| • | select the schema for editing in the explorer tree (type the first letters of the schema name for quick search); |
| • | select the Edit Schema... item from the popup menu |
or
| • | open the database in Database Editor and the Schemas tab there; |
| • | select the schema to edit; |
| • | press the Enter key or select the Edit Schema item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
You can change the name of the schema using the Rename Schema dialog. To open the dialog you should either
| • | select the schema to rename in the explorer tree; |
| • | select the Rename Schema item from the popup menu |
or
| • | open the database in Database Editor and the Schemas tab there; |
| • | select the schema to rename; |
| • | select the Rename Schema item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar). |
|
To drop a schema:
| • | select the schema to drop in the explorer tree; |
| • | select the Drop Schema item from popup menu |
or
| • | open the database in Database Editor and the Schemas tab there; |
| • | select the schema to drop; |
| • | press the Delete key or select the Drop Schema item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar) |
and confirm dropping in the dialog window.
|
Partners
Download
Buy
