You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <de...@db.apache.org> on 2006/03/30 18:07:27 UTC
[jira] Commented: (DERBY-1164) 'show tables' and 'describe'
commands in ij
[ http://issues.apache.org/jira/browse/DERBY-1164?page=comments#action_12372461 ]
Rick Hillegas commented on DERBY-1164:
--------------------------------------
Hi Håvard,
Thanks for this useful patch. The parser productions look good to me. However, I'm hesitant about modelling the result as a vector. I think it would be better to return results which look more like tables rather than coalescing all the information into a single column. I think you will end up with something more powerful if you write an implementation of ijResult which wraps a ResultSet. This will let you rapidly display all sorts of DatabaseMetaData calls.
> 'show tables' and 'describe' commands in ij
> -------------------------------------------
>
> Key: DERBY-1164
> URL: http://issues.apache.org/jira/browse/DERBY-1164
> Project: Derby
> Type: New Feature
> Components: Tools
> Reporter: Håvard Mork
> Priority: Trivial
> Attachments: 1164.diff
>
> New users migrating from mysql are familiar with commands 'show tables' and 'describe' to respectively display all permanent tables, and show fields in a given table. These are not standard sql, but I suggest to implement them only in the IJ tool for user-friendliness.
> As suggested in db-dev, using DatabaseMetaData should provide the necessary query strings.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira