The SYSCOLUMNS doc https://www.lianja.com/doc/index.php/SYSCOLUMNS has the following 2 definitions listed:
and
What's the difference?
I can imagine a difference: in VFP there is no such thing as a NULL value of a table field. It can be empty, with a system-supplied default value, but it will never be NULL. So one of these might be that, and the other might be "this field cannot be set to NULL, and the record will not SAVE if it is."
I understand the NULL and NOT NULL SQL Constraints: On and Off flags. I don't understand these two.
Additionally, Nullable is list as N (2). I am puzzled.
thanks,
Hank
Bookmarks