db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Håvard Mork (JIRA) <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1164) 'show tables' and 'describe' commands in ij
Date Fri, 07 Apr 2006 22:54:25 GMT
     [ 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


Mime
View raw message