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

Teradata Vantageā„¢ Time Series Tables and Operations

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1208-162K
Language
English (United States)
Last Update
2019-05-02

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.

HELP 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