Yes. I just wanted to be 100% sure about SQL Server since I know precious little about that system.
>Yes. Isn't it the same in Oracle? There's also system stored procedure sp_pkeys that returns PK info for one table. It also includes column that specifies order of columns in PK. You can use it's source code to directly access SQL Server system tables which is not recomended by MS.
Mark McCasland
Midlothian, TX USA