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.
