You can translate the question and the replies:

find base view from query

Hi Team, Denodo 7.0 Is there any scripted way (stored procedure), which can tell what base views are created from query and what otherwise. Please help. Thnaks.
user
07-06-2019 04:31:14 -0400

3 Answers

Please tell.
user
10-06-2019 01:34:03 -0400
Please help.
user
11-06-2019 01:43:30 -0400
Hi, If the base view is created from a query, the query will be in the SQL sentence column of the GET_SOURCE_TABLE(<database>, <base_view>). If the query is created otherwise this column will be null. For more details on the stored procedure you can refer the following document: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_table#get-source-table Hope this helps!
Denodo Team
11-06-2019 13:26:06 -0400
You must sign in to add an answer. If you do not have an account, you can register here