db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: Equivlent to MySQL DESCRIBE statement?
Date Thu, 10 Feb 2005 21:44:35 GMT
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

Mime
View raw message