Hi
I am not still clear where I should introduce tables feilds Not Null and where not. Can you help me?
thanks
Not Null
Moderator: General Moderators
Re: Not Null
In most situations you should not use NOT NULL unless the field is one that you want to make absolutely certain contains data in every record. A primary key is an obvious example, but also for fields which, if blank, make the data useless, such as LastName in a directory of people. Using it anywhere else raises the potential that at some point you will want to enter a record that has no data in the field (perhaps expecting to fill it in later) and your database will refuse to allow you to enter the record. Believe me, it happens all the time.m2babaey wrote:I am not still clear where I should introduce tables feilds Not Null and where not. Can you help me?