17.00 - ConstraintType Column - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K
Value Description
C Explicit table-level constraint check
P Nonpartitioned Primary Index
Q Partitioning constraint
S Hash-ordered Secondary Index without ALL
K Primary key
U Unique constraint
R References constraint
V Value-ordered Secondary Index without ALL
H Hash-ordered Secondary Index with ALL
O Value-ordered secondary with ALL