Define Primary Key and Indices Constraints - Teradata Administrator

Teradata Administrator User Guide
Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Define Primary Key and Indices Constraints

Selecting either Primary Key or Index/Unique from the Constraint button in the Create Table dialog box displays the Define Primary Key and Indices dialog box. Enter the INDEX specifications for the table that is being created.

Note: Add an ANSI Unique constraint by defining a unique secondary index on the unique columns.

 

Table 15: Define Primary Key and Indices Dialog Box Description 

Field or Control

Description

Indices

Displays the name of each index specified for the table. Selecting an index in the list then reflects its specifications in the Index Columns list and in the configuration of the primary and secondary index type option buttons.

Name

Specify an optional name for the index. The specified name is displayed in the Indices list when the Add button is used to save the index specification.

Note: Index names are optional. If a name is not entered in this field, index type (primary or secondary) is displayed in the Indices list and creates the table without an index name specification.

Type

Click Primary or Secondary to add the respective index type attribute to the index.

Note: Each table can have only one primary index.

Unique

Select this check box to add the UNIQUE attribute to the index.

Table Columns

This list shows all of the columns specified for the table.

Select the columns whose values are used as the basis for an index or constraint specification.

To add columns

✔ Do one of the following:

  • From the Table Columns list, double-click on the column name to add it to the Index Columns list.
  • Or, click once to highlight the column and click Add to add it to the Index Columns list.

    • Index Columns

    Shows all of the columns selected to provide index or constraint value.

    To remove columns

    ✔ Do one of the following:

  • From the Index Columns list, double-click on the column name to remove it from the Index Columns list.
  • Or, click once to highlight the column and click Remove.