In my database i have table valued function. In its definition nullability of column is not set directly. This column has a user-defined data type. So the question is: is this column nullable? As i can see here: http://msdn.microsoft.com/en-us/library/ms174979.aspx
When column nullability is not explicitly specified, column nullability follows the rules shown in the following table.
Column data type
Alias data type
The Database Engine uses the nullability that is specified when the data
type was created. To determine the default nullability of the data type, use sp_help.
It should be not null, as user defined type is declared as not null.
SMO says, that column is not null, but schema compare says it is nullable. Who is wrong and why?
View Complete Post