Here is an interesting blog post about sys.system_internals_partition_columns.

http://www.sqlskills.com/blogs/paul/how-are-per-column-modification-counts-tracked/[/url]

Regarding sys.sysindexes that contains information not only about indexes, but also about column-statistics.

Ola Hallengren

http://ola.hallengren.com