skip to main |
skip to sidebar
how to find the list of views that are created on a table in teradata
the following query gives the list of views that are created on a table.
select tablename from dbc.tables where TableKind='V' and RequestText LIKE '%Table%' group by 1 order by 1;
In place of Table specify your table name.for example if i want to find the list of views that are created on table test1,i will use the following query.
select tablename from dbc.tables where TableKind='V' and RequestText LIKE '%test1%' group by 1 order by 1;
The query displays
TableName
------------------------------
view1
view2
view3
No comments:
Post a Comment