db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: no information about "sys" in documentation of "sysschemas"
Date Fri, 10 Feb 2006 07:11:33 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
May be all system table names in the heading could have SYS schema
added to them. If you want, you can file a documentation improvement
request in JIRA.<br>
<br>
At the beginning of system table section, the following clarifies it
though.<br>
<br>
<u><b>Derby System Tables</b></u><br>
Derby includes system tables.<br>
You can query system tables, but you cannot alter them.<br>
<b>All of the above system tables reside in the SYS schema.</b> Because
this is not the default<br>
schema, qualify all queries accessing the system tables with the SYS
schema name.<br>
The recommended way to get more information about these tables is to
use an instance<br>
of the Java interface java.sql.DatabaseMetaData.<br>
<br>
Satheesh<br>
<br>
Torsten Bittner wrote:<br>
<blockquote
 cite="midOF0425569F.3C088521-ON87257111.000D778C-88257111.000DC1A7@us.ibm.com"
 type="cite"><br>
  <font face="sans-serif" size="2">Hi.</font>
  <br>
  <font face="sans-serif" size="2">on this side in the documentation
for
derby</font>
  <br>
  <font face="sans-serif" size="2"><a class="moz-txt-link-freetext" href="http://db.apache.org/derby/docs/10.0/manuals/reference/sqlj165.html#IDX1071">http://db.apache.org/derby/docs/10.0/manuals/reference/sqlj165.html#IDX1071</a></font>
  <br>
  <br>
  <font face="sans-serif" size="2">there is the information misssing
that
the table SYSTABLES exists in the schema SYS</font>
  <br>
  <br>
  <font face="sans-serif" size="2">I tried to do a "SELECT * FROM
SYSTABLES" which did not work. Please add somewhere that it is "SELECT
* FROM <b>SYS.SYSTABLES</b>". </font>
  <br>
  <br>
  <font face="sans-serif" size="2">Please update the information or
forward
my request to the right people.</font>
  <br>
  <br>
  <font face="sans-serif" size="2">Maybe the information is somewhere
else,
but it's defenitely missing in the documentation of SYSTABLES.</font>
  <br>
  <br>
  <font face="sans-serif" size="2">I don't want anybody else to waste
as
much time as I just did in the last two hours figuring this out.</font>
  <br>
  <br>
  <font face="sans-serif" size="2">Thanks,</font>
  <br>
  <font face="sans-serif" size="2">Torsten</font>
  <br>
  <br>
  <font face="sans-serif" size="2">Torsten Bittner<br>
WebSphere II Tooling - Metadata<br>
Email: <a class="moz-txt-link-abbreviated" href="mailto:tbittner@us.ibm.com">tbittner@us.ibm.com</a></font>
</blockquote>
</body>
</html>


Mime
View raw message