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