how to find indexes in sql tables

Report · May 15, 2009

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.

Report · Jun 05, 2009

I think you can use one of the built-in db functions ... (but it depends upon which database you're using)

in sql server:

sp_helpindex tablename