List all Indexes on all tables in given database.

Question

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

nkohad SSC Enthusiast Points: 109 More actions · Answer 1

hi mahesh,

u can use

sysobjects

sysindexes

sysreferences

system tables.

The primary key is ID.

I would have given u the query but I don't have enough time.

ok bye

nitin

Mahesh-122174 SSC-Addicted Points: 483 More actions · Answer 2

Hello Nitin,

I would appriciate even if you send me on monday, my mail id is mpbalshetwar@hotmail.com.

Thanks,

MaheshB

nkohad SSC Enthusiast Points: 109 More actions · Answer 3

hi mahesh,

i'll try today itself.

Otherwise i'll send u at ur emailid.

ok bye

nitin

noeld SSC Guru Points: 96590 More actions · Answer 4

This may give you a little more than what you asked for but it is simple and easy to use:

DBCC SHOWCONTIG WITH TABLERESULTS , ALL_INDEXES

* Noel

jason stephens Newbie Points: 1 More actions · Answer 5

This will sort you out: