How I can find the list of Sybase Indexes for a given database?

indexing isql
aartist picture aartist · Sep 23, 2009 · Viewed 33.3k times · Source

How I can find the list of Indexes for a given database in Sybase?

Answer

Paul Harrington picture Paul Harrington · Sep 24, 2009 
Query against sysobjects and sysindexes:
SELECT o.name,
       i.name
  FROM sysobjects o
  JOIN sysindexes i
    ON (o.id = i.id)

Documentation on the interpretation of the sysobjects and sysindexes system tables is available on the Sybase web-site.

Load up stored procedure library from http://www.edbarlow.com/ and type in sp__helpindex

or use the Sybase-provided sp_helpindex which expects the table-name as a parameter.

Related questions

Finding the index of an item in a list

Given a list ["foo", "bar", "baz"] and an item in the list "bar", how do I get its index (1) in Python?

Read More
Getting the last element of a list

In Python, how do you get the last element of a list?

Read More
Python Pandas: Get index of rows which column matches certain value

Given a DataFrame with a column "BoolCol", we want to find the indexes of the DataFrame in which the values for "BoolCol" == True I currently have the iterating way to do it, which works perfectly: for i in range(100,3000): if …

Read More