sp_helpindex equivalent in Informix

Posted in 2007

gary.hampson@gmail.com — 8 May 2007 14:48:21 -0700 — source: Usenet: comp.databases.informix

Hello, I am a SQL Server developer recently introduced to Informix here at work and would like to know if there is an Informix equivalent to SQL Server's "sp_helpindex" or a command that lists the indexed columns on a table. Many thanks.. Gary Hampson

↪ replying to gary.hampson@gmail.com

Obnoxio The Clown — Tue, 08 May 2007 22:54:46 +0100 — source: Usenet: comp.databases.informix

gary.hampson@gmail.com wrote: > Hello, > > I am a SQL Server developer recently introduced to Informix here at > work and would like to know if there is an Informix equivalent to SQL > Server's "sp_helpindex" or a command that lists the indexed columns on > a table. > > dbaccess <dbname> q(uery) i(info) tablename<enter> i(ndex) -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to Obnoxio The Clown

Jonathan Leffler — 9 May 2007 06:55:59 -0700 — source: Usenet: comp.databases.informix

On May 8, 2:54 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > gary.hamp...@gmail.com wrote: > > Hello, > > > I am a SQL Server developer recently introduced to Informix here at > > work and would like to know if there is an Informix equivalent to SQL > > Server's "sp_helpindex" or a command that lists the indexed columns on > > a table. > > dbaccess <dbname> > q(uery) > i(info) > tablename<enter> > i(ndex) Or, in the query language (interpreted by DB-Access): INFO INDEXES FOR SomeTable; Feature also available in SQLCMD, with totally different output format.