Creates a global temporary trace table to support the UDF- and external SQL procedure-related trace option of the SET SESSION statement. See SET SESSION FUNCTION TRACE.
You cannot partition or define indexes for a global temporary trace table.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have the CREATE TABLE privilege on the database or user in which the table is created.
The creator receives all the following privileges on the newly created table.
- DROP TEMPORARY TABLE
- DUMP
- REFERENCES
- RESTORE
- SELECT
Privileges Granted Automatically
None.