SYSUIF.UIF_V Example | Teradata Vantage - 17.10 - Example: Using SYSUIF.UIF_V - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

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

The following SELECT statement displays the UIFs that are accessible by database or user ID 00000104.

SELECT * from sysuif.uif_v;

Result:

 DatabaseId 00000104
UIFFileName r2.r
   TVMNameI R2
      UIFId 0000060A0000
 DatabaseId 00000104
UIFFileName p1.py
   TVMNameI P1
      UIFId 0000070A0000