Table Attributes and Options
Field or Control |
Description |
Table Type |
Specify the following type for the new table: |
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. |
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: 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: 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: Note: Activate the Constraint button by specifying the table name and at least one column name. |