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.
Required Privileges
The following privileges are required to run a SHOW request against the specified objects.
- Any privilege on the user-defined function, hash index, 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.
- At least one privilege on the SYSUDTLIB database.
- The UDTUSAGE privilege on the UDT.
- The SELECT privilege on the DBC.TVM table.
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.