确定检查IS_IDENTITY和/或IN_PRIMARY_KEY的表字段？

Question

I am trying to determine the table column which has been identified as (or part there of) the primary key for a given table name.

I have been playing around with the INFORMATION_SCHEMA and the data within it, but nothing seems to relate to these table columns.

Have also been browsing around this website:

http://msdn.microsoft.com/en-us/library/aa933201%28v=sql.80%29.aspx

but without much luck so far.

Anyone have any suggestions?

Answer 1

I actually found what I was looking for here