in my project few of the tables have collect stats on some columns...
Could you guys let me know how to get on what tables having collect stats on what fields???
Depends on your release:
For TD14 you get it from dbc.StatsV, before it's in various dbc views (column/index/multicolumn-StatsV) or better try my stats query to get more details: