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

What is an indexed view?

1005

What command would you use to add a column to a table in sql server?

1356

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1070

Is oracle faster than sql server?

1004

Give an example of why you would want to denormalize a database

1028

If no size is defined while creating the database, what size will the database have?

1034

Explain different types of lock modes in sql server 2000?

980

What are various aggregate functions that are available?

1039

What is self contained multi valued query?

1074

Does group by or order by come first?

996

Explain indexed views?

1027

What is the data type of time?

1014

‘Order by’ is not allowed in a view how can you sort information from a view?

1120

Give main differences between "Truncate" and "Delete".

1150

What is BCNF? How is it better than 2NF & 3NF?

1065