Knowing unused columns within a table 0
These are a little scripts that i did at my work, i needed to know all columns that does not has a value (in other words, ‘detect’ which columns are not use within the application).
This script requieres the schema and table name and the result will show you which columns are null.
This one requiere the shema name and the result will show you all columns from all tables are null in the given schema.
PD: Scripts only works in Oracle, but it’s easy to code in any other RDBMS
