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