Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1531437800.1144450465044.JavaMail.jira@ajax>
Date: Fri, 7 Apr 2006 23:54:25 +0100 (BST)
From: =?utf-8?Q?H=C3=A5vard_Mork_=28JIRA=29?= <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-1164) 'show tables' and 'describe' commands
 in ij
In-Reply-To: <1962252478.1143640343803.JavaMail.jira@ajax>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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

H=C3=A5vard Mork updated DERBY-1164:
-------------------------------

    Attachment: 1164_3.diff

Thanks for the review. I agree with what was pointed out regarding the inte=
nded 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 a=
re 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=C3=A5vard Mork
>     Priority: Trivial
>  Attachments: 1164.diff, 1164_2.diff, 1164_3.diff
>
> New users migrating from mysql are familiar with commands 'show tables' a=
nd 'describe'  to respectively display all permanent tables, and show field=
s 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 necessa=
ry query strings.

--=20
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