db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "ListFileNamesOfTables" by StanleyBradbury
Date Wed, 09 May 2012 23:02:57 GMT
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=diff&rev1=1&rev2=2

  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 query aborts and there
are tables that have not been checked.  Note the name of the table listed in the exception
and rerun the query excluding the problem 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 = t.schemaid
-    and t.tabletype = 'T'
-    and tablename not in (<tableX>,<tableY>,<table...>);
- }}}
  

Mime
View raw message