You can translate the question and the replies:

There are 3 columns in the Denodo view SCHEMA- Field name, Field Type & Description. I am trying to access/view “Description” column .how to update/modify the desc field for 20/30 columns. is there a way to update or import .please let me know

There are 3 columns in the Denodo derived view SCHEMA- Field name, Field Type & Description. I am trying to access/view “Description” column .how to update/modify the desc field for 20/30 columns. is there a way to update or import .please let me know
user
13-04-2020 13:49:16 -0400

1 Answer

Hi, I used the following commands in a script in order to change many view descriptions at the same time: ``` #For base views ALTER TABLE <base_view> ( ALTER COLUMN <column_name> ADD (DESCRIPTION = '<your description>') ); #For derived views ALTER VIEW <view_name> ( ALTER COLUMN <column_name> ADD (DESCRIPTION = '<your description>') ) ``` You can create your own script by using one of these VQL statements for each of your columns and substituting the corresponding view name, field name, and description text into the statement. For more information about modifying views with VQL, you can refer to this similar [Q&A question](https://community.denodo.com/answers/question/details?questionId=9060g000000XetMAAS&title=Update+view+descriptions+and+columns+descriptions+Automatically). I hope this helps!
Denodo Team
14-04-2020 19:38:05 -0400
You must sign in to add an answer. If you do not have an account, you can register here