Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 71669 invoked from network); 6 Dec 2006 14:56:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Dec 2006 14:56:48 -0000 Received: (qmail 89418 invoked by uid 500); 6 Dec 2006 14:56:54 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 89389 invoked by uid 500); 6 Dec 2006 14:56:53 -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 89370 invoked by uid 99); 6 Dec 2006 14:56:53 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Dec 2006 06:56:53 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Dec 2006 06:56:44 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id BA10A7142FD for ; Wed, 6 Dec 2006 06:56:24 -0800 (PST) Message-ID: <20767735.1165416984759.JavaMail.jira@brutus> Date: Wed, 6 Dec 2006 06:56:24 -0800 (PST) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-1209) It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables In-Reply-To: <982309451.1144888619596.JavaMail.jira@ajax> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ http://issues.apache.org/jira/browse/DERBY-1209?page=all ] Rick Hillegas updated DERBY-1209: --------------------------------- Fix Version/s: 10.2.3.0 (was: 10.2.2.0) Move to 10.2.3.0. > It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables > ---------------------------------------------------------------------------------------------------------------- > > Key: DERBY-1209 > URL: http://issues.apache.org/jira/browse/DERBY-1209 > Project: Derby > Issue Type: Improvement > Components: Documentation > Affects Versions: 10.2.1.6, 10.1.3.1 > Reporter: Kathey Marsden > Priority: Minor > Fix For: 10.2.3.0 > > > It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables: > http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html > e.g. > SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, > tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid = > t.schemaid; -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira