You can translate the question and the replies:

Create VQL that will generate a list of all views and fields and descriptons

Is there a simple way to write a VQL script that not only shows all of the views -- i.e. LIST VIEWS on [database] but also would show the **view** and the **columns, and field type** from that view... (as well as **description** if possible). We are trying to get this type of export at anytime during our development process. ideally it would look like this *database | view name | column | field type | description* Thanks for any help you can provide.
user
25-02-2021 08:27:05 -0500

2 Answers

I think I found the simple solution. CALL GET_VIEW_COLUMNS('[database]');
user
25-02-2021 09:19:27 -0500
Hi, I am glad that you were able to figure out the solution. If I need to get information about the views like column name, field type etc, I would use the [GET_VIEW_COLUMNS()](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_view_columns) or the [CATALOG_VDP_METADATA_VIEWS()](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_vdp_metadata_views) predefined Stored Procedures of Denodo Platform. Hope this helps!
Denodo Team
26-02-2021 04:03:57 -0500
You must sign in to add an answer. If you do not have an account, you can register here