Return-Path: 
 <derby-commits-return-15575-apmail-db-derby-commits-archive=db.apache.org@db.apache.org>
X-Original-To: apmail-db-derby-commits-archive@www.apache.org
Delivered-To: apmail-db-derby-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 9CBCDC0A1
	for <apmail-db-derby-commits-archive@www.apache.org>;
 Wed,  9 May 2012 23:03:18 +0000 (UTC)
Received: (qmail 66978 invoked by uid 500); 9 May 2012 23:03:18 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 66924 invoked by uid 500); 9 May 2012 23:03:18 -0000
Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-commits-help@db.apache.org>
list-unsubscribe: <mailto:derby-commits-unsubscribe@db.apache.org>
List-Post: <mailto:derby-commits@db.apache.org>
Reply-To: "Derby Development" <derby-dev@db.apache.org>
List-Id: <derby-commits.db.apache.org>
Delivered-To: mailing list derby-commits@db.apache.org
Received: (qmail 66916 invoked by uid 99); 9 May 2012 23:03:18 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 May 2012 23:03:18 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.131] (HELO eos.apache.org) (140.211.11.131)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 May 2012 23:03:17 +0000
Received: from eos.apache.org (localhost [127.0.0.1])
	by eos.apache.org (Postfix) with ESMTP id 562A9DC
	for <derby-commits@db.apache.org>; Wed,  9 May 2012 23:02:57 +0000 (UTC)
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
From: Apache Wiki <wikidiffs@apache.org>
To: Apache Wiki <wikidiffs@apache.org>
Date: Wed, 09 May 2012 23:02:57 -0000
Message-ID: <20120509230257.92331.38012@eos.apache.org>
Subject: 
 =?utf-8?q?=5BDb-derby_Wiki=5D_Update_of_=22ListFileNamesOfTables=22_by_St?=
 =?utf-8?q?anleyBradbury?=
Auto-Submitted: auto-generated
X-Virus-Checked: Checked by ClamAV on apache.org

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for =
change notification.

The "ListFileNamesOfTables" page has been changed by StanleyBradbury:
http://wiki.apache.org/db-derby/ListFileNamesOfTables?action=3Ddiff&rev1=3D=
1&rev2=3D2

  order by file;
  }}}
  =

+ Dear WIKI admin:  How am I supposed to know what city ApacheCon was held =
in many years ago???  Could you ask less obtuse questions?
- is reported you are done, all is well.  If an exception is thrown the que=
ry aborts and there are tables that have not been checked.  Note the name o=
f the table listed in the exception and rerun the query excluding the probl=
em table. {{{
- SELECT schemaname || '.' || tablename as TableName,
-    SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename) AS OK
- FROM sys.sysschemas s, sys.systables t
- WHERE s.schemaid =3D t.schemaid
-    and t.tabletype =3D 'T'
-    and tablename not in (<tableX>,<tableY>,<table...>);
- }}}
 =20