SHOW TABLE SQL Statement | Teradata Vantage - 17.10 - SHOW TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

Displays the most recent SQL create text.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

To use SHOW TABLE, you must have one of the following privileges:
  • Any privilege on the table, or any privilege on the database containing the table.
  • At least one privilege on the DBC.TVM table.