Show tables ? + 2 Feature requests

Bart Pietercil bart.pietercil at gmail.com
Wed Sep 19 07:05:47 CDT 2007


Hi List, Ruslan

1) When running the "show tables" command, the query result also  
includes VIEWS.

Is this by design or a bug. If by design I would suggest updating the  
WIKI with the explanation that not only tables are included (as it  
states now) but also views.


2) Feature request: When running the show tables query the result  
includes a field called text where , for views, the create statement  
is stored.
Would it be possible to do the same (store the create statement in  
the text field) for tables. This would make it easier to copy tables  
from one db to another, instead of dumping a table to disk (sql) and  
the opening the .sql file copying the create statement and pasting  
this in the SQL editor.
I do realise that the create statement would need to include the  
alter table statement in order to define the links.

An alternative could be that somehow we would have a "copy to  
clipboard" button in the Dump SQL dialog (probably easier to implement)

3) May I repeat an earlier FR to have the possibility to include  
comments for all Valentina Objects (Table, Field, Link, Method). I do  
realise that this is overkill for most projects, but I can assure you  
that having this for big projects where multiple people are working  
on a common database, this feature would be very welcomed. I am sure  
PostgreSQL has it and I think this is also true for other major db  
engines


TIA

Bart Pietercil


More information about the Valentina mailing list