15.10 - NoPI Tables - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

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).