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/
>>
>>
>>
>
|