Query DBC Tables/Columns To Find Empty Columns

Database
Enthusiast

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

3 REPLIES
Enthusiast

Re: Query DBC Tables/Columns To Find Empty Columns

You'll need to query the table itself.

Rglass

Enthusiast

Re: Query DBC Tables/Columns To Find Empty Columns

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.

Teradata Employee

Re: Query DBC Tables/Columns To Find Empty Columns

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.