Table Attributes and Options - Teradata Administrator

Teradata Administrator User Guide
Product
Teradata Administrator
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2502
Product Category
Teradata Tools and Utilities
 

Table 13: Create Table Dialog Box Description 

Field or Control

Description

Table Type

Specify the following type for the new table:

  • Teradata – Create a SET table. Duplicate rows are not allowed.
  • ANSI – Create a MultiSet table. Duplicate rows are allowed.
  • NoPI – Create a table with no primary index. NoPI tables are always ANSI and cannot have journals.
  • Queue – Create a Queue Table. Queue tables cannot be temporary or have journals. These tables require a Not Null Timestamp (6) field as the first column.

    • Table Name

    The name of the new table

    In Database

    The name of the database in which to create the table. If a database is not specified, the new table is created in the default database for the current session.

    Note: The In Database field is not equivalent to the optional IN DATABASE clause of the SQL CREATE TABLE command.

    Journal Table

    The table used to store change journal images for the new table.

    By default, Teradata Administrator creates the journal table in the same database as the new table.

    Enter the journal table name specification as either:

    tname

    or

    dbname.tname

    Where:

    tname is the journal table name
    dbname is the optional database name

    Provide a journal table name if: 1) a journal option is specified for the new table and 2) there is no default journal table specified for the database in which this table is being created.

    Block Size

    The maximum size of the data blocks, in bytes, for the table.

    The actual maximum block size is the number entered in the Block Size field rounded to the nearest multiple of the 512 byte disk sector size.

    The minimum size is 8192. The maximum is 127.5K (255 sectors).

    Free Space

    This specification, entered as a percentage, determines the amount of space to be left on each cylinder when the table is loaded. This allows users to insert extra data rows without incurring the additional system overhead associated with rearranging data blocks.

    The minimum free space specification is 0%; the maximum is 75%.

    MergeBlockRatio

    This field is used by the FileSystem to determine the maximum size of a merged datablock. The value is interpreted as a percentage of the maximum multi-row datablock size applicable to the table to which the block belongs.

    Enter a value from 1–100. The default value is 60.

    Checksum

    Specify the level of disk I/O integrity checking to perform on this table. The Low, Medium and High values are user-definable, and can be set by your system administrator.

  • Default – uses the CheckSum default the system administrator sets.
  • None – disables disk I/O integrity checking.
  • All – samples 100% of the words in each disk sector of a data block.

    • Temporary

    Create a Global Temporary table that can be instantiated by a user at a later date.

    No Log

    When a Temporary table is created, select this option to not keep a transaction log of changes to this table.

    Preserve

    When a Temporary table is created, select this option to preserve the rows in the table after a transaction commits. The default for a Temporary table is to delete (not preserve) the rows as soon as the transaction is committed.

    FallBack

    Specifies that this table is created with fallback protection.

    Before Journal

    Specifies the journaling requirement for “before” change row images as follows:

  • Yes – specifies a single journal.
  • No – specifies no journal.
  • Dual – specifies dual journals.

    • These are actual journaling requirements when specified on the Create Table dialog box, or Default values when specified on the Create Database dialog box.

    After Journal

    Specifies the journaling requirement for “after” change row images:

  • Yes – specifies a single journal on a different AMP from changed row.
  • No – specifies no journal.
  • Dual – specifies dual journals.
  • Local – specifies a single journal on the same AMP as changed row.

    • These are actual journaling requirements when specified on the Create Table dialog box, or Default values when specified on the Create Database dialog box.

    The Local option is only available for non-FallBack tables.

    Constraint

    Displays a menu with the following choices for selecting the type of constraint to define:

  • Primary Key – See “Define Primary Key and Indices Constraints” on page 61.
  • Index/Unique – See “Define Primary Key and Indices Constraints” on page 61.
  • Check – See “Define Check Constraints” on page 62.
  • Foreign Key – See “Define Foreign Key Constraints” on page 63.
  • Security – See “Add a Security Constraint Column to a Table” on page 78. This feature only displays when connected to Teradata Database 14.0 and above.

    • Note: Activate the Constraint button by specifying the table name and at least one column name.