16.20 - HELP DATABASE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Time Series Tables and Operations

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

HELP DATABASE output includes the attribute Table Flavor for each table defined in the database to indicate whether or not the table is a PTI table, as shown in the table below.

Table Flavor Value
PTI table S
Non-PTI table NULL

Example: HELP DATABASE with PTI Tables

This statement displays information for the database, TS_Database.


The output for the PTI table tstab2 includes the Table Flavor attribute with a value of S and table Kind value T to indicate a PTI table.

           Table/View/Macro name tstab2
                            Kind T
                         Comment ?
                      Protection N
                    Creator Name DBC
                   Commit Option N
                 Transaction Log Y
Table/View/Macro Dictionary Name tstab2
       Table/View/Macro SQL Name tstab2
   Table/View/Macro Name UEscape ?
         Creator Dictionary Name DBC
                Creator SQL Name DBC
            Creator Name UEscape ?
                    Table Flavor S