db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Show tables
Date Mon, 27 Mar 2006 19:24:56 GMT
Hi Håvard,

I agree that this would be a great idea. Hopefully, DatabaseMetaData has 
all the queries you need and you won't have to hand-write your own SQL.

Thanks!
-Rick

Rajesh Kartha wrote:

>> I was thinking about the possibility to extend IJ to allow 'show
>> tables', and possibly 'show table'.
>
>
>
> I think 'show tables' is a good idea. (Is the 'show table' , you 
> mentioned, same as 'describe table")
>
> 'describe table' is another useful command to have that will show the 
> data types of
> each table. Currently one can achieve this by writing a  query on the 
> system tables. A simple
> command will be really useful.
>
> And as Satheesh suggested these could be ij commands.
>
> -Rajesh
>
> Håvard Mork wrote:
>
>> Hello,
>>
>> I was thinking about the possibility to extend IJ to allow 'show
>> tables', and possibly 'show table'. Having worked a lot with mysql, I
>> was missing these commands when I first started working with Derby,
>> and I would be glad to see them introduced.
>>
>> Is this a good or a bad idea? 'Show tables' is not standard sql
>> standard, but the 'select' syntax for listing tables seem to differ
>> between most database systems. I would suggest implementing 'show
>> tables' as an alias for a query to sys.systables for printing table
>> names.
>>
>> Any feedback is appreciated.
>>
>> -- 
>> Mvh,
>>  Håvard Mork
>>  http://folk.ntnu.no/havarmor/
>>
>>  
>>
>


Mime
View raw message