Thursday, February 9, 2012

all indexes in DB

Hi all,
I want to know all indexes in database.
What do I do to get them?
Thanks in advanced,
Thi Nguyenthe sysindexes-table might get your started. From BOL: "Contains one row for each index and table in the database. This table is stored in each database".|||No, I want to know all names of indexes in database.|||No, I want to know all names of indexes in database.
select name from sysindexes|||that is good.
I just want to get user defined index names, not all names.

Thanks
Thi Nguyen

No comments:

Post a Comment