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/
