db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lance J. Andersen" <Lance.Ander...@Sun.COM>
Subject Re: Equivlent to MySQL DESCRIBE statement?
Date Thu, 10 Feb 2005 21:48:42 GMT
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.

Jean T. Anderson wrote:

> Jonathan Eric Miller wrote:
>> Does anyone know if Derby has an equivalent to the MySQL DESCRIBE 
>> statement? In MySQL, you can issue a command like the following to 
>> find out the structure of a table. i.e. list the columns, types, 
>> indexes, etc.
>> DESCRIBE <tableName>;
>> Jon
> dblook lets you dump the schema for a database, schema, or a table:
> http://incubator.apache.org/derby/manuals/tools/tools108.html
> It'd be easy to write a SQL function to do the same and generate the 
> output in whatever format you'd like.
> -jean

View raw message