Show TOC

Primary Indexes (Teradata)Locate this document in the navigation structure

In Teradata, users tend to use indexes rather than key constraints.

Procedure

  1. Open the property sheet of an index from the Indexes tab of a table, or from the List of Indexes available by selecting Start of the navigation path Model Next navigation step Indexes End of the navigation path.
  2. Click the Teradata tab and select the Primary Index checkbox.
  3. Click OK to close the index property sheet.

    When a primary index is based on a key, it is automatically unique. You can make this primary index non-unique by detaching the index from the key. To do so, select <None> in the Columns Definition list in the Columns tab of the index property sheet, and set the PrimaryIndex extended attribute of the index to True.

    Once defined, you can decide to generate indexes or keys in the SQL script, and you can also decide to generate them inside or outside the table creation script.