Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BDD77B411 for ; Fri, 20 Jan 2012 02:49:46 +0000 (UTC) Received: (qmail 96982 invoked by uid 500); 20 Jan 2012 02:49:46 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 96680 invoked by uid 500); 20 Jan 2012 02:49:40 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 96672 invoked by uid 99); 20 Jan 2012 02:49:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2012 02:49:38 +0000 X-ASF-Spam-Status: No, hits=1.0 required=5.0 tests=FORGED_YAHOO_RCVD,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Jan 2012 02:49:32 +0000 Received: from isper.nabble.com ([192.168.236.156]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Ro4XP-0001Xc-LA for derby-user@db.apache.org; Thu, 19 Jan 2012 18:49:11 -0800 Message-ID: <33171994.post@talk.nabble.com> Date: Thu, 19 Jan 2012 18:49:11 -0800 (PST) From: ollie2308 To: derby-user@db.apache.org Subject: List columns that make up an index MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: ollie2308@yahoo.com Hi I am having trouble writing a query that uses the derby system tables to return all index names and the columns and their order that make up the indexes. Any help would be appreciated. Thanks -- View this message in context: http://old.nabble.com/List-columns-that-make-up-an-index-tp33171994p33171994.html Sent from the Apache Derby Users mailing list archive at Nabble.com.