|
Home > Archive > MS SQL Server > October 2006 > How do I find unique indexes in SQL-server 2005.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How do I find unique indexes in SQL-server 2005.
|
|
| ben brugman 2006-10-24, 6:33 pm |
| I am trying to get to grips with a database.
At the moment I am locking at contraints in general.
Most I can find in the information_schema views.
(Is there a webpage or -site which does describe this ?).
But how do I find indexes which are not implemented as constraints,
especially 'unique - indexes' ?
Thanks for your time and attention,
ben brugman
| |
| Hilary Cotter 2006-10-24, 6:33 pm |
| select sysobjects.name from sysobjects join
sysindexes on sysobjects.id=sysindexes.id
where sysindexes.status=2 and type='u'
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ben brugman" <ben@niethier.nl> wrote in message
news:OaBHeCg5GHA.1256@TK2MSFTNGP04.phx.gbl...
>I am trying to get to grips with a database.
>
> At the moment I am locking at contraints in general.
> Most I can find in the information_schema views.
> (Is there a webpage or -site which does describe this ?).
>
> But how do I find indexes which are not implemented as constraints,
> especially 'unique - indexes' ?
>
> Thanks for your time and attention,
> ben brugman
>
|
|
|
|
|