He, he this one pops up again and again. I also would like this. - Try to check
if there is a JIRA or this.
Below a -mail thread from earlier discussions.
Personally I am using the Derby Plugin to Eclipse for wandering around my
tables.
Bernd
Hi,
Meanwhile, here is a SQL that can get the table description;
For example: A table 'ATAB" with schema name 'SAM'
---------------------------------------------------------
ij> create table sam.atab(id int, col1 char(2));
ij> select columnname, columndatatype from sys.syscolumns where
referenceid in (select tableid from sys.systables a, sys.sysschemas b where
a.schemaid=b.schemaid and b.schemaname='SAM' and a.tablename='ATAB'); COLUMNNAME
|COLUMNDATATYPE
-----------------------------------------------------------------------------------------------------------------------------
-------------------
COL1
|CHAR(2)
ID
|INTEGER
I guess the above can be used in a SQL function, which can then be executed the
normal way ('ij' or java application).
-Rajesh
Jonathan Eric Miller wrote:
> I'm guessing that at some point there will be UNIX shell scripts/DOS
> command files for commands such as ij, dblook, and starting Derby as a
> network server?
>
> Jon
>
> ----- Original Message ----- From: "Lance J. Andersen"
> <[EMAIL PROTECTED]>
> To: "Derby Discussion" <[email protected]>
> Sent: Thursday, February 10, 2005 3:48 PM
> Subject: Re: Equivlent to MySQL DESCRIBE statement?
>
>
>> dblook is fine, but it would still be useful to have a command or SQL
>> function that is readily available that can be run from ij for
>> example. Most people are used to having something like sp_help or
>> describe or show to accomplish this from a sql command line interface
>> such as ij.
>
>
> -----Original Message-----
> From: Lujop [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 09, 2005 2:32 PM
> To: [email protected]
> Subject: Description of a table
>
> Hello,
>
> How can I get the description of a table with IJ?
>
> A lot of thanks in advance,
> --
> ---
> Joan Jesús Pujol Espinar
> ----------------------------------------------------------------------
> This e-mail, including any attached files, may contain
> confidential and privileged information for the sole use of
> the intended recipient. Any review, use, distribution, or
> disclosure by others is strictly prohibited. If you are not
> the intended recipient (or authorized to receive information
> for the intended recipient), please contact the sender by
> reply e-mail and delete all copies of this message.
>
----------------------------------------------------------------------
This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient. Any review,
use, distribution, or disclosure by others is strictly prohibited. If you are
not the intended recipient (or authorized to receive information for the
intended recipient), please contact the sender by reply e-mail and delete all
copies of this message.
