Indexes, primary keys constraint type from sysconstraints -table?

Where I can found information that what indexes are primary keys,
and where is the information of constraints type in sysconstarint table?
I readed drom help that field sysconstraints.status should tell it, but I
have mystique values in this field,
such as 3105, 2069, 133141 etc... Data type is bitmap, how I can compare
bitmaps and integers?
Hi
Don't query system tables directly.
Use the Information Schema Views, together with OBJECTPROPERTY and
COLUMNPROPERTY
All the information is easily usable then.
Look those up in BOL.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Major" wrote:

> Where I can found information that what indexes are primary keys,
> and where is the information of constraints type in sysconstarint table?
> I readed drom help that field sysconstraints.status should tell it, but I
> have mystique values in this field,
> such as 3105, 2069, 133141 etc... Data type is bitmap, how I can compare
> bitmaps and integers?
>
>
|||hi
i think you can find it by using this query
select * from information_schema.table_constraints
Siddharth
"Major" wrote:

> Where I can found information that what indexes are primary keys,
> and where is the information of constraints type in sysconstarint table?
> I readed drom help that field sysconstraints.status should tell it, but I
> have mystique values in this field,
> such as 3105, 2069, 133141 etc... Data type is bitmap, how I can compare
> bitmaps and integers?
>
>