The Database Design Resource Center

The author fails to consider the valid uses for null columns

by KRoth

The author presents 1 side of an argument that has as much information out there in favor of using Nulls as not. Google the uses of nulls and you will see for yourself.

People have preferences and the author's preference is to avoid allowing null in a database column. How the author ever expects to know when a field is "virginal" and completely untouched is beyond me. A default value fails to solve this problem. Requiring the user/system to provide a value also fails to solve the issue of knowing when the field has never had a value before.

Perhaps the argument is to use nulls sparingly when they are required for the project at hand rather than denouncing a concept that has successfully solved a real business problem that has existed since the beginnings of databases.

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to On NULL values.

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.