db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen (JIRA) <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1164) 'show tables' and 'describe' commands in ij
Date Fri, 31 Mar 2006 08:45:29 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1164?page=comments#action_12372646 ] 

Øystein Grøvlen commented on DERBY-1164:

Nice start.  I think some more work is needed to make this really useful:

1. Display length for character types, precision for numerics
2. Display information on primary keys and nullability
3. Not require schema name, and look for tables in current schema in that case.  I think many
of those who will benefit the most from this command, may not necessarily know much about
schemas.  They just use the default schema.
4. Would be nice to have a 'show schemas' command
5. Would ne nice to be able to list tables within a given schema.

> '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:
For more information on JIRA, see:

View raw message