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

How can you find out how many rows returned in a cursor?

547

When would you use the stored procedures or functions?

567

how to define testing of network layers? : Sql server database administration

480

What is the difference between DATETIME2 and DATETIME?

617

What are the five major components of a dbms?

508

What is an identity column in insert statements?

577

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

590

Explain system scalar functions?

569

is there a column to which a default can't be bound? : Sql server database administration

529

What is the openxml statement in sql server?

532

How many databases can we create in a single server?

187

What are the default system databases in sql server 2000?

531

How to call a function from a stored procedure in SQL Server ?

542

What is coalesce and check constraint in sql server?

537

How are the exceptions handled in sql server programming?

601