All Forums Database
newton1965 12 posts Joined 06/13
22 Jul 2014
Query DBC Tables/Columns To Find Empty Columns

Is there an easy DBC query to check any table to identify columns that are not being populated (empty)?
Thanks

Glass 225 posts Joined 04/10
22 Jul 2014

You'll need to query the table itself.
 
Rglass

Raja_KT 1246 posts Joined 07/09
22 Jul 2014

I dont think any database will have this option(dictionary) to check or they will make it if it is meant for huge database. Their engine will be really too busy.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

ToddAWalter 316 posts Joined 10/11
22 Jul 2014

A column is never empty. It always has some defined content. That content might be NULL, it might be a default value specified in the column definition, it might be some default value specified in a load job or initialized in the table at the time a column is added via an ALTER, but it always has some value. And a column is always populated with some value (NULL, default,...) during any DML or load utility operation.
It will be necessary to look at the sematics of each column to determine whether a column is being populated as you desire.

You must sign in to leave a comment.