Finding empty columns
Hello everyone
As part of an effort in the company to analyze the data in our databases, I've been asked to find out what columns are not being populated by our systems.
I had planned on runnin many:
select count(1) from <table> where <fieldname> = NULL
but it seems like we have over 100,000 fields in our database, so, this task would take a very long time. I imagine there must be a better way to find what fields are not being populated??
Any suggestion will be appretiated.
-OG