How to get index information INFORMATION_SCHEMA? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

How to get index information INFORMATION_SCHEMA?

Author

Topic

tfountain
Constraint Violating Yak Guru

491 Posts

Posted - 2003-02-06 : 10:21:53

How would I query the INFORMATION_SCHEMA views to find out attributes of an index or constraint? For example, how would I find out if the index/constraint is clustered versus nonclustered?

LarsG
Constraint Violating Yak Guru

284 Posts

Posted - 2003-02-06 : 10:46:09

indexes and clustered/no clustered attributes are not part of information_schema as there are no such concepts in the standard.

You have to use system tables.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-i_76wj.asp

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-02-06 : 10:57:04

There's also sp_help and sp_helpindex.

tfountain
Constraint Violating Yak Guru

491 Posts

Posted - 2003-02-06 : 11:42:09

Thanks for the input. Guess I'll stick to the way that works ;).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources