15.00 - HELP INDEX and NoPI Tables, Column-Partitioned Tables, and Column-Partitioned Join Indexes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

HELP INDEX and NoPI Tables, Column‑Partitioned Tables, and Column‑Partitioned Join Indexes

A table or join index with column partitioning cannot have a primary index, so Teradata Database does not return a row for a primary index for a NoPI table, a column‑partitioned table, or a column‑partitioned join index.

Because of this, a HELP INDEX request cannot be used to determine whether or not a table or join index is column partitioned.