470,631 Members | 1,994 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,631 developers. It's quick & easy.

Catalog query

Hello, How can I identity the list of columns (with the table in which
it is located) present in a database which has
[1] A blank or NULL value for ALL rows ( if the column is CHAR)
[2] A zero (0) for ALL the rows (if it is a numeric column)

Is there is any system.catalog entry which I can query to find out ?

Thanks, Sam

Nov 27 '06 #1
1 1650
Ian
Sam Durai wrote:
Hello, How can I identity the list of columns (with the table in which
it is located) present in a database which has
[1] A blank or NULL value for ALL rows ( if the column is CHAR)
[2] A zero (0) for ALL the rows (if it is a numeric column)

Is there is any system.catalog entry which I can query to find out ?
No. You must query the actual tables to get accurate results.

However, if you've have recent statistics on the tables, you may be
able to get a rough idea by looking at syscat.tables (CARD) and
syscat.columns (COLCARD, HIGH2KEY, LOW2KEY, NUMNULLS, ...)
Nov 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jefferis NoSpamme | last post: by
reply views Thread by Roisin | last post: by
reply views Thread by Denise | last post: by
reply views Thread by Vasantha peddireddy | last post: by
3 posts views Thread by maricel | last post: by
3 posts views Thread by mike | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.