Creating a Database

A relational database is a database that has a set of tables which is manipulated in accordance with the relational model of data. It contains a set of data objects used to store, manage, and access data. Examples of such data objects are tables, views, indexes, functions and so on.

Follow the steps below to create a database:

  1. In the Object Browser pane, right-click the selected Databases group and select Create Database.

    Note

    This operation can be performed only when there is at least one active database.

    A Create Database dialog box is displayed prompting you to provide the necessary information to create the database.

  2. Enter the database name. Refer to the server manual for database naming rules.

  3. Select the required type of encoding character set from the Database Encoding drop-down list.

    The database supports UTF-8, GBK, SQL_ASCII, and LATIN1 types of encoding character sets. Creating the database with other encoding character sets may result in erroneous operations.

  4. Select the Connect to the DB check box and click OK.

    The status bar displays the status of the completed operation.

    You can view the created database in the Object Browser. The system related schema present in the server is automatically added to the new database.

    Note

    Data Studio allows you to login even if the password has expired with a message informing that some operations may not work as expected when no other database is connected in that connection profile. Refer to Password Expiry for information to change this behavior.

Cancelling Connection

Follow the steps below to cancel the connection operation:

  1. Double-click the status bar to open the Progress View tab.

  2. In the Progress View tab, click image1.

  3. In the Cancel Operation dialog box, click Yes.

    The status bar displays the status of the cancelled operation.