Skip to main content
C
cfnew
Known Participant
May 15, 2009
Question

how to find indexes in sql tables

  • May 15, 2009
  • 1 reply
  • 825 views

Hi i need help for how to find the indexes for the sql tables.I had some tables in sql 2005 and i need to find indexes for that tables.Can anyone will help in this isssue.

This topic has been closed for replies.

1 reply

ilssac
ilssac
Inspiring
May 15, 2009

All database management systems store this information in system tables.  You just need to query those tables for this information.  Your Database Management System documentation should tell you the details on these tables.

-
-__cfSearching__-
Inspiring
May 16, 2009

You can also obtain this information using the object browser in SQL Server Management Studio GUI.  To obtain metadata using t-sql, your best bet is to consult the books online as Ian suggested. They are your best reference for t-sql:

Your question about indexes is listed in the FAQ's:

http://msdn.microsoft.com/en-us/library/ms345522.aspx

Also helpful is the documentation on the Information_Schema Views
http://msdn.microsoft.com/en-us/library/ms186778(SQL.90).aspx

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices