[ http://issues.apache.org/jira/browse/DERBY-1164?page=all ]

Håvard Mork updated DERBY-1164:
-------------------------------

    Attachment: 1164_3.diff

Thanks for the review. I agree with what was pointed out regarding the intended 
use of ij.

One thing that puzzled me was the 'getTableTypes' and 'getTable' entries in 
metadata.properties. They both mention tables, system tables, and views,  but 
they have no entries for synonyms. I don't understand issues regarding version 
compatibility of metadata.properties well, so please say if there are any 
problems.

> '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, 1164_2.diff, 1164_3.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

Reply via email to