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/
