SHOW TABLE for Time Series Tables | Teradata Vantage - 17.10 - SHOW TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

You can use SHOW TABLE to display the table definition for a PTI table. The output includes the system generated TD_TIMEBUCKET, TD_TIMECODE, and TD_SEQNO columns for PTI Tables. For complete information about SHOW TABLE syntax, see Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.

To use the SHOW TABLE statement, you must have at least one privilege on the database containing the table.