Physical Modeling › Teradata Physical Property Editors › Define a Teradata Database

Define a Teradata Database

You can use the Database editor to manage databases so that other database objects can be created and stored in it in a Teradata physical model.

To define a Teradata database

  1. Click Databases on the Database menu.

    The Database Editor opens.

  2. Select a database and work with the following options:

    Note: Click New <New> icon in property editors on the toolbar to create a new database.

    Name

    Specifies the name of the database.

    Account

    Specify the account to be charged for the space used by this database.

    From Database

    Specifies the schema of the database to which the table belongs. Select from the drop-down.

    Generate

    Generates DDL for this object during Forward Engineering.

  3. Complete the following fields on the General tab:
    Database Options
    Permanent

    Specifies the number of bytes to be reserved for the permanent storage of this database.

    Spool

    Specifies the number of bytes to be allowed for spool and volatile temporary files.

    Temporary

    Defines how many bytes are allowed for creating global temporary tables by users within the database.

    Fallback Protection

    Specifies the type of fallback protection for the database. Select from the drop-down.

    Journal Options
    Before Journal Image

    Specifies the image type of the before journal image. Select from the drop-down list. Valid values are: None, Single, and Dual.

    After Journal Image

    Specifies the image type of the after journal image. Select from the drop-down list. Valid values are: None, Single, Dual, Local, and Not Local.

    Default Journal

    Specifies the default table that is to receive the journal images of tables created in the database.

  4. Click the Permissions tab to associate permissions with the selected database. Features on the Permissions tab enable you to create new permissions, work with existing permissions, and open the Permission Editor to define permission options.
  5. (Optional) Click the Comment tab and enter any comments you want associated with the database.
  6. (Optional) Click the UDP tab to work with user-defined properties for the database.
  7. Click Close.

    The Database Editor closes.

More information:

Add Permissions in a Teradata Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor