You can translate the question and the replies:

Can we define a column at a derived view level as nullable 'false'

I have a requirement, where I need to define a column of a derived view as not nullable even if it is not a primary key. I made it at the base view level but when I checked the derived view using the stored procedure 'get_view_columns' it is showing nullable 'true'. Is there any possibility to change it, instead of making it as a primary key?
15-06-2023 10:13:29 -0400

2 Answers

I also tried, but i am not able to do that. if any one knows how define column is not null at dv level with out key
15-06-2023 14:40:47 -0400
Hi, You cannot define not null field in derived view, but it can be achieved in base view where there is Nullable field with check box in edit tab of the view. Defining as a primary key is an option to mark a field as a not null. Thanks
Denodo Team
22-06-2023 03:58:42 -0400
You must sign in to add an answer. If you do not have an account, you can register here