RE: Indexes, primary keys constraint type from sysconstraints -table?
- From: "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx>
- Date: Tue, 7 Jun 2005 02:53:25 -0700
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?
>
>
>
.
- References:
- Prev by Date: Indexes, primary keys constraint type from sysconstraints -table?
- Next by Date: RE: Indexes, primary keys constraint type from sysconstraints -table?
- Previous by thread: Indexes, primary keys constraint type from sysconstraints -table?
- Next by thread: RE: Indexes, primary keys constraint type from sysconstraints -table?
- Index(es):
Relevant Pages
|
