DB2 : Need to get the list of columns and distinct value counts for a given db2 table

66 Views Asked by At

For data profiling purpose , I just need to get the idea if a columns in a given table has values populated or not. For that, I need to get the list of columns and distinct value counts for a given db2 table.

1

There are 1 best solutions below

0
On

If you are using Db2 for Linux, Unix or Windows you could try

SELECT TABSCHEMA, TABNAME, COLNAME, COLCARD FROM SYSCAT.COLUMNS