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

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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