Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 63109 invoked from network); 21 May 2007 19:48:06 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 May 2007 19:48:06 -0000 Received: (qmail 99128 invoked by uid 500); 21 May 2007 19:48:11 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 99053 invoked by uid 500); 21 May 2007 19:48:11 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 99044 invoked by uid 99); 21 May 2007 19:48:11 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 May 2007 12:48:11 -0700 X-ASF-Spam-Status: No, hits=0.9 required=10.0 tests=FORGED_YAHOO_RCVD,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 May 2007 12:48:03 -0700 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1HqDr5-0002Gd-8I for derby-dev@db.apache.org; Mon, 21 May 2007 12:47:43 -0700 Message-ID: <10725655.post@talk.nabble.com> Date: Mon, 21 May 2007 12:47:43 -0700 (PDT) From: ollie2308 To: derby-dev@db.apache.org Subject: query for Primary Key Columns MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: ollie2308@yahoo.com X-Virus-Checked: Checked by ClamAV on apache.org Hello, ... new to derby database and want to query the system tables to obtain the column names that make up each tables primary key. Can this be done via a query ? Can find table name, constraint name, constraint type, but can not get the columns that make up the pk Thanks -- View this message in context: http://www.nabble.com/query-for-Primary-Key-Columns-tf3792418.html#a10725655 Sent from the Apache Derby Developers mailing list archive at Nabble.com.