dictionary view for primary keys

Hello,

Is there a dictionary view I can query that will list the columns in a given table and their constraints - ie) primary key, foreign key, unique.

I'm sure there is a view that has this info, but I can't find it.

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 13 1999 - 09:09:54 CST