Should fields that are set to Not Null also have a constraint refusing empty strings?

2 votes

2 answers

1256 views

sql-server null check-constraints fields

                          Any field that I would expect a value (Like an orderNumber or customerNumber) I would set as not nullable. 

If I'm expecting the value of the field to be not null, shouldn't I also always have a constraint that does not allow for zero length strings or space only strings?

Asked by Elias (179 rep)

Apr 22, 2020, 07:21 PM
Last activity: Apr 22, 2020, 09:14 PM

Should fields that are set to Not Null also have a constraint refusing empty strings?

Related Questions