SQLTables - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

The 16.20 database has a new table called a Primary Time Index (PTI) table. For details about PTI tables, refer to Detailed Feature External Specification for Time Series. The TD ODBC Driver 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.