SQL Server How do I know if a field can have NULL values or not?

rsl1atfo  于 5个月前  发布在  其他
关注(0)|答案(1)|浏览(60)

I have a table with a field that indicates it is not nullable . In Delphi when I do a Select * from Table and inspect this specific field I see the Required property is false, but I expect it to say True. From my understanding TField.Required should reflect the Nullable property, but it seems not so in this particular case.

If TField.Required is not the right property to use how do I detect whether the field can be NULL or not?

vptzau2j

vptzau2j1#

Will be opening a case at Embarcaderro. Have found the exact same issue now with a FireDac dataset where ADO dataset reports the field as Not Required, while the same is reported as Required by FireDac.

相关问题