msprop:nullValue="_empty" -- (Empty)
msprop:nullValue="_null" -- (Nothing)
msprop:nullValue="_throw" -- (Throw exception)
msprop:nullValue="_throw" is the default value and it is not persisted by default.
The xpath queries I used were:
--Find string columns with no null value prop
/xs:schema/xs:element/xs:complexType/xs:choice/xs:element/xs:complexType/xs:sequence/xs:element[(child::xs:simpleType/xs:restriction/@base='xs:string') and (not(@msprop:nullValue))]
and
--Find nodes where value exists and is not '_empty'
xs:schema/xs:element/xs:complexType/xs:choice/xs:element/xs:complexType/xs:sequence/xs:element[xs:simpleType/xs:restriction/@base='xs:string']/@msprop:nullValue[.!='_empty']