sp_help <tablename> sp_helpindex <tablename>

How do you know which index a table is using?

Question Posted / visala

Answer Posted / visala

sp_help <tablename>
sp_helpindex <tablename>

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

whats new about truncate in sql server 2008?

2487

Where are full-text indexes stored?

977

What is the difference between inner join and equi join?

974

What is self join in sql server joins?

1034

How to enter binary string literals in ms sql server?

1131

What are “lost updates”?

983

What are group functions in query statements in ms sql server?

983

Explain Geography datatype in SQL Server

1111

How ssrs maintain security?

1061

What is the difference between a "where" clause and a "having" clause?

1149

Is sql different from sql server?

1058

What is transaction server explicit transaction?

1015

Can we delete data from a view?

913

What is sql azure database?

206

How can you find out which stored procedures are recompiling?

910