ALL Null or Empty columns identifcation in single query
MySQL version: 5.1.73
we have created lot of custom fields out of which only 30% is actually used. Is there any way to identify unused custom fields in a table and remove it using a SINGLE QUERY?
I can find out such info on column by column basis but wanted to know if there was any way where we can find all unused column info (with DBA privs) and create such query
Subject
Written By
Posted
ALL Null or Empty columns identifcation in single query
November 24, 2014 11:08PM
November 25, 2014 01:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.