NoPI Tables - ODBC Driver for Teradata - 16.20

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

Tables with no primary index (NoPI tables) are supported in ODBC Driver for Teradata. NoPI tables are included in the result set from SQLTables with the TABLE_TYPE “TABLE” as are tables with primary indexes.

A NoPI table can be recognized by the absence of a row for the primary index in the result set from SQLStatistics (no rows with index TYPE equal to SQL_INDEX_CLUSTERED).