IdentifyTable Function | Application Programming Reference | Teradata Vantage - 17.10 - IdentifyTable - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Returns the name of the specified table ID.

Syntax

REPLACE FUNCTION SYSLIB.IdentifyTable (
  TableID  INTEGER
) RETURNS VARCHAR(128) CHARACTER SET UNICODE
  ...
;

Syntax Elements

TableID
ID of the locked table.

Usage Notes

The IdentifyTable function provides similar functionality to the PMPC IDENTIFY TABLE request. For information about this interface, see IDENTIFY.

Example: Using IdentifyTable

SELECT IdentifyUser(blk1userid) as "blocking user",
    IdentifyTable(blk1objtid) as "blocking table",
    IdentifyDatabase(blk1objdbid) as "blocking db"
FROM TABLE (MonitorSession(-1,'*',0)) AS t1
WHERE Blk1UserId > 0;
 *** Query completed. One row found. 3 columns returned.
 *** Total elapsed time was 4 seconds.
blocking user                blocking table          blocking db
---------------------------  ----------------------- -------------
user1                        skewAmp1                DBaaa