Listing out indexes of all databases of all servers

My requirement is to excute a job from a centralised server which lists out indexes of all databases of all servers. Please help me out to achieve this.
SQLM_MAsked:
Who is Participating?
 
Pratima PharandeConnect With a Mentor Commented:
try this

SELECT DISTINCT      TABLE_NAME,      INDEX_NAME  FROM INFORMATION_SCHEMA.STATISTICS


Also this will you some more infor about schema etc

SELECT * INFORMATION_SCHEMA.STATISTICS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.