Subject | Finding out all unused columns in all tables |
---|---|
Author | Venus Software Operations |
Post date | 2013-07-28T07:30:16Z |
Hi all
I have a production database which needs to be identified of all the
columns in all the tables that are unused. Is there an SQL of kinds
that can create a list of such columns. A column that is null and / or
default value filled for all rows is what I think is an empty column.
Please advise
Thanks and regards
Bhavbhuti
I have a production database which needs to be identified of all the
columns in all the tables that are unused. Is there an SQL of kinds
that can create a list of such columns. A column that is null and / or
default value filled for all rows is what I think is an empty column.
Please advise
Thanks and regards
Bhavbhuti