SHOW object SQL Statement | VantageCloud Lake - SHOW object

For tables, macros and views, displays the SQL data definition text for the original create text from DBC.TVM.RequestText.

For information on displaying statistics information, see SHOW STATISTICS.

Also see the following sections:

ANSI Compliance

The following statements and associated options are Teradata extensions to the ANSI SQL:2011 standard:

SHOW AUTHORIZATION
SHOW CAST
SHOW CONSTRAINT
SHOW ERROR TABLE FOR
SHOW FUNCTION
SHOW GLOP SET
SHOW JOIN INDEX
SHOW MACRO
SHOW PROCEDURE
SHOW SPECIFIC FUNCTION
SHOW TABLE error_table_name
SHOW TABLE table_name
SHOW TRIGGER
SHOW VIEW

Required Privileges

The following privileges are required to run a SHOW request against the specified objects.

To use SHOW ERROR TABLE FOR, SHOW FUNCTION, SHOW JOIN INDEX, SHOW MACRO, SHOW PROCEDURE, SHOW TABLE, or SHOW VIEW, you must have one of the following privileges:

Any privilege on the user-defined function, join index, macro, SQL procedure, GLOP set, table, or view, or any privilege on the database containing it.
At least one privilege on the DBC.TVM table.
SHOW FUNCTION for an SQL function requires any privilege on the function or its containing database or the SELECT privilege on the DBC.TVM table.

To use SHOW FUNCTION to show the C source code text for an external UDF, you must also have the DROP privilege on the function; otherwise, you can only display the CREATE FUNCTION text.

You do not need the DROP privilege on the function to show the SQL source code text for an SQL UDF.

To use SHOW CONSTRAINT, you must have either the CONSTRAINT DEFINITION or CONSTRAINT ASSIGNMENT privilege.

To use SHOW AUTHORIZATION, you must have the DROP AUTHORIZATION privilege on the authorization object.

Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against the specified database object.

SHOW object SQL Statement | VantageCloud Lake - SHOW object - Teradata VantageCloud Lake

Lake - Working with SQL

ANSI Compliance

Required Privileges