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
