|
The Create Database right click menu is available only to those
database vendors and versions that directly support "database" as a
schema object.
Those vendors are:
- Informix
- Microsoft SQL
- MySQL
- nCluster
- PostgreSQL
- Sybase
Within the Schema Browser, connections that support database
creation will have a databases container underneath the connection
icon when the server connection tree is expanded. Once a server
connection has been established, creating a database can be done by
right clicking on the connection in the Schema Browser and
selecting, "Create Database".
Aqua Data Studio strictly follows the functionality and API
(application programming interface) provided by each database
vendor, and therefore cannot provide a direct graphical method for
database creation in Apache, DB2, Oracle and Teradata.
The database server connections which do not directly support
"database" as a schema object - Apache, DB2, Oracle, Teradata
- may have Database Administration
Tools for managing Tablespaces and Storage and Instances. See
the DBA
Tools section for more on the tools available in Aqua Data
Studio. Server connections to these vendors do not include a
database container within their expanded trees in the Schema
Browser. They will have My Schema and Schema containers which then
contain tables other objects.
The screenshot displays a MySQL Server that allows the creation
of a database in the Schema Browser Tree. Below it, an Oracle
11g server connection has been expanded to reveal it does not have
a databases container. There are containers for My Schema and
Schema.
ALTER Database
Existing Databases can also be ALTERed through the Visual
Editing tools. Right clicking on a database allows selection
of "Alter Database"
DROP Database
The Visual Editing tools also allow users to DROP an existing
database through right click in the Schema Browser.
|
