list all view and their VDB

Hi, is there a View in Denodo which can provide me list of all the views and their corresponding VDB available on a server ? Currently the only option i find is using 1. LIST VIEWS ALL : but it only provides Views of the VDB i am logged in 2. catalog_elements(): provides Views name at the VDB level I am looking to compare 2 separate denodo server through a script to find out missing Views and their corresponding VBDB's
user
05-10-2017 08:54:30 -0400

2 Answers

i think i have found what i need using GET_ELEMENTS()
user
05-10-2017 12:15:07 -0400
Hi, You are correct in using the GET_ELEMENTS(), as this stored procedure returns the information of any element, data sources, views, web services etc. To know more refer to [GET_ELEMENTS](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_elements#get-elements) of the Virtual DataPort VQL Guide. Thanks.
Denodo Team
06-10-2017 04:27:29 -0400
You must sign in to add an answer. If you do not have an account, you can register here