dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Aug 24, 2005

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Retrieve All the Index Names for a Given Table Using SQL Query

Use this code to retrieve all the Index names for a given table Using SQL query:

declare @tblName varchar(50);
set @tblName = 'GivenTable';
SELECT     o.name as TableName, i.name AS IndexName
FROM         sysobjects o, sysindexes i
WHERE   (o.id = i.id and o.name = @tblName) AND (i.status = 18450 OR   i.status = 2097152)
i.status = 18450 indicates a clustered index (or, primary key index) in the given table. i.status = 2097152 indicates a non-clustered index in the given table.

Note: @tblName is input parameter to the query. This query is applicable for MS SQL Server 2000.

Jaya Nehru Kumar
 
Thanks for your registration, follow us on our social networks to keep up-to-date