Take the 2-minute tour ×  When creating a View based on a PIVOT
query all the view fields become NULLABLE in the view metadata,
is there any way to make them NOT NULLABLE?  I'm using the NVL
function in the pivoted fields I need to be NOT NULL but they
still become NULLABLE.  This is a problem to me because I'm
using MS Entity Framework and it won't update the model based on
tables or views without NOT NULLABLE columns.  share|improve
this question possible duplicate of Oracle: How to create a not
null column in a view –  DazzaL Jan 22 '13 at 12:19 I don't
think it applies on solving my problem. Since even if I create a
new virtual column in the table being queried the PIVOT function
will just turn that field nullable too. Am I missing something?
–  Miguel Matos Jan 22 '13 at 13:45 It being a PIVOT query is
probably tangential to your core problem with the view metadata.
–  Jeffrey Kemp Jan 23 '13 at 7:50 @MiguelMatos What version of
VS are you using? –  bluefeet Jan 25 '13 at 20:22 @bluefeet
VS2010 –  Miguel