sp_helpindex command gives the information of the indexes on the table

How do you know which index a table is using?

Question Posted / chandra rekha

Answer Posted / chandra rekha

sp_helpindex command gives the information of the indexes
on the table

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the rendering extensions of ssrs?

157

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

157

How to create an inline table-valued function?

982

what are constraints? : Sql server database administration

1063

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

988

How to create an identity column?

1228

can we have a nested transaction? : Sql server database administration

1106

System variable and temporary variables

2260

What command is used to delete a table from the database in the sql server and how?

1121

What are translations and its use? : sql server analysis services, ssas

1049

What are the filtered indexes?

1043

Explain a checkpoint?

1045

What do you mean by stored techniques? How would we use it?

1043

How to list all user defined functions in the current database?

1055

List out what other servers you can use with ssrs?

139