You can translate the question and the replies:

View column order metadata

I am using Denodo 7, latest update. I'm using get_view_columns() to extract metadata on columns included in views for various purposes. There doesn't seem to be anything that provides the order of the columns in the views. Is this metadata available anywhere within the catalog?
metadata get_view_columns column order
user
12-10-2018 08:17:03 -0400
code

1 Answer

Hi, The *GET_VIEW_COLUMNS* returns information about the fields of the views. This information includes the type of field, length, precision in case of numbers, etc. The order that the column names are retrieved through the stored procedure is by default following the schema of the view. Currently, there isn’t a way to retrieve the column order information. You may refer to the [GET_VIEW_COLUMNS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_view_columns) section of the Virtual DataPort VQL Guide for more information. Hope this helps!
Denodo Team
15-10-2018 05:53:36 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here