Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

List of indexs on a table

2 posts in General Discussion Last posting was on 2012-07-09 09:42:25.0Z
Joe Posted on 2012-07-09 07:39:42.0Z
Sender: 1e5b.4ffa74f6.1804289383@sybase.com
From: Joe
Newsgroups: sybase.public.ase.general
Subject: List of indexs on a table
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ffa8abd.20ff.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Jul 2012 00:39:42 -0700
X-Trace: forums-1-dub 1341819582 172.20.134.41 (9 Jul 2012 00:39:42 -0700)
X-Original-Trace: 9 Jul 2012 00:39:42 -0700, 172.20.134.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31224
Article PK: 74112

Hello,
Is there any way to find list of indexes on a particular
table.
Like
1. clustered index on xyztable (col1,col2,col3)
2. non clustered index on xyztable ( col1,col4)

thanks
-Joe


Rob V Posted on 2012-07-09 09:42:25.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:13.0) Gecko/20120614 Thunderbird/13.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: List of indexs on a table
References: <4ffa8abd.20ff.1681692777@sybase.com>
In-Reply-To: <4ffa8abd.20ff.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ffaa781$1@forums-1-dub>
Date: 9 Jul 2012 02:42:25 -0700
X-Trace: forums-1-dub 1341826945 172.20.134.152 (9 Jul 2012 02:42:25 -0700)
X-Original-Trace: 9 Jul 2012 02:42:25 -0700, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31227
Article PK: 74114


On 09-Jul-2012 09:39, Joe wrote:
> Hello,
> Is there any way to find list of indexes on a particular
> table.
> Like
> 1. clustered index on xyztable (col1,col2,col3)
> 2. non clustered index on xyztable ( col1,col4)
>
> thanks
> -Joe
>

Run sp_helpindex your_table or sp_help your_table

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------