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
