16.20 - IdentifyTable - Teradata Vantage NewSQL Engine

Teradata Vantage™ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

Purpose

Returns the name of the specified table ID.

Definition

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

Input Parameter

Parameter Description
TableID ID of the locked table.

Usage Notes - IdentifyTable

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

Return Value

This function returns the name of the table.

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