Hello,
Is there a simple way to query all views depend on a schema or table?
E.g.,
view_schema| view_name | depends on schema_name | depends on t1
===========|===========|========================|================
v_schema |v1 | test | t1
"v_schema.v1" is defined as select .... from test.t1... where;
Thanks a lot!