Hi,
For your scenario, I would use ["DESC VIEW <view name>"](https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/appendix/output_schema_of_the_desc_commands/output_schema_of_the_desc_commands#:~:text=DESC%20VIEW%20%3Cview%20name%3E) 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](https://community.denodo.com/answers/question/details?questionId=9064u0000004FgOAAU&title=How+to+get+the+all+views+mandatory+Filtes%3F) .
Hope this helps!!
