15.00 - Miscellaneous Information - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Miscellaneous Information

  • Column name
  • Identity column
  • Primary key/foreign key
  • Constraint number
  • Primary index/secondary index
  • Note the following things about this point.

  • This form is filled out during the logical design phase and indexes should not be defined this soon in the process.
  • A table might be a nonpartitioned NoPI object, and a table or join index might be a column‑partitioned object, in which case it would not have a primary index.
  • Sample data
  • Transcribe this information from the completed Column Names and Constraints form to the Table form.