17.20 - SQLTables - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

Starting with Advanced SQL Engine 16.20, there is a new table called a Primary Time Index (PTI) table. For details about PTI tables, refer to Detailed Feature External Specification for Time Series. ODBC Driver for Teradata does not add any additional functionalities to handle this new table type, but the ODBC API function SQLTables now returns one additional column described in the following table:

Column Name Column Number Data Type Comment
TD_TABLE_FLAVOR 6 varchar Contains “PRIMARY TIME INDEX” for PTI tables. Null if table is not a PTI table.