Show tables

[Håvard Mork <ha...@gmail.com>]

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/

Re: Show tables

[Satheesh Bandaram <sa...@Sourcery.Org>]

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.
>  
>
I think this is a very good idea... I have been seeing requests for this
kind of IJ commands from the beginning of Derby project. :-)  I believe
these can be implemented as IJ only commands very easily.

>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.
>  
>
Are you thinking of adding them as SQL statements that engine
recognises? I would rather see them as IJ commands, that only IJ
understands. There are several IJ commands that are not recognised in
engine... like GET CURSOR for example. It should be possible to add
several new IJ commands that translate into regular SQL statements
against system tables to display required information.

Satheesh

>Any feedback is appreciated.
>
>--
>Mvh,
>  Håvard Mork
>  http://folk.ntnu.no/havarmor/
>
>
>
>  
>

Re: Show tables

[Rick Hillegas <Ri...@Sun.COM>]

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

Re: Show tables

[Rajesh Kartha <ka...@gmail.com>]

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