15.00 - Definition of a Non-Prime Table - Teradata Database

Teradata Database Design

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

Definition of a Non-Prime Table

A non-prime table is a table that has a composite primary key.

The following table, Table_B, is non-prime because it has a composite primary key (see the definition for “Composite key” under “Definitions” on page 75):

 

Table_B

 

B_Key_1

B_Key_2

PK

B1_1

B2_3

B1_2

B2_2

B1_3

B2_1