You can translate the question and the replies:

Overview of the obligatoryfields

Hi, is there a DENODO standard view for querying mandatory/obligatory fields and the associated views? Thx for your help!
29-11-2022 01:56:12 -0500

1 Answer

Hi, For your scenario, I would use ["DESC VIEW <view name>"]( command in the VQL shell. There I would get the Mandatory field details under “capacities” section of the output with the constraint **“OBL”**. For instance: > DESC VIEW student The view “student” has two fields “id” and “name” where “id” is a obligatory field. If the above command is executed in the VQL shell, you could see the name of fields and its type like below in the “capacities” section. ADD id (=) OBL ONE #mandatory field ADD name NOS ZERO () #normal field You could use this way for finding the mandatory fields of the view. At the moment, there is no standard view in Denodo to get the mandatory field related details. You could also refer to the similar community available [here]( . Hope this helps!!
Denodo Team
29-11-2022 06:55:34 -0500
You must sign in to add an answer. If you do not have an account, you can register here