how to find indexes in sql tables

[cfnew]

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.

[ilssac]

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__-]

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