Query to know clustered index

Question

Post reply

Query to know clustered index

Ak-763166

Right there with Babe

Points: 772
More actions
October 7, 2008 at 4:10 am

#75333

Hi All,
Is there any query to know if what are the indexes on a table and whether the indexes are clustered or not?
Thanks for your replies.
Regards
Amit

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

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

Sanaullah SSC Eights! Points: 892 More actions · Answer 1

Hi Amit,

SP_HELP

In this you will get all information.

Thanks,

Syed Sanaullah Khadri

Sergiy SSC Guru Points: 110208 More actions · Answer 2

indid = 1 means the index is clustered.

_____________
Code for TallyGenerator

Sanaullah SSC Eights! Points: 892 More actions · Answer 3

I dont know about indid=1 but

When you execute SP_HELP tablename, below you will get the index created on the table and its type and on which column it is created.

Ak-763166 Right there with Babe Points: 772 More actions · Answer 4

Ak-763166

Right there with Babe

Points: 772

March 4, 2009 at 10:24 pm

#953776

Hi All,

Thanks for your help.

Cheers,

A.

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 5

Sp_help TableName gives you lots of information about the table, and this information includes data about the indexes. If you only want to see information about the indexes then you can use sp_helpindex TableName instead of sp_help

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/