SQLServerCentral » Latest topics
Find fields, where all values are NULL
Hi all!
I have to go through several 100 tables.
Many of them hae not used fields, where all fields are NULL
To find it it one field in one table is pretty uncomplicated, something like:
SELECT COUNT(BES_END_DATO_BESOEG)FRO
I have to go through several 100 tables.
Many of them hae not used fields, where all fields are NULL
To find it it one field in one table is pretty uncomplicated, something like:
SELECT COUNT(BES_END_DATO_BESOEG)FRO
No comments:
Post a Comment