I continue ‘fight’ with Database Diagrams [DD]:
a. to new DD I dropped a single table, but all related tables has been added
imho I should be asked if I want to add related tables or not.
b. context manu for table is unavailable when I press right mouse in ‘red’ area
c .references: there is no simple information about columns and referenced
I have to analyze through table properties.
There shall by context menu /info for references. It would be grate if option to
generate /view sql
from this point will be available.
There shall by possibility to jump to referenced table [when relation is
d. To add lookup tables I have to point column second table is referenced by. It
is very inconvenient.
e. finally I added new lookup table and… a lot of related to this [see issue
f. there is no option ‘remove table from diagram’ in context manu for tables!
g. when deleting [pressing ‘del’] single table from diagram, all other tables
are repainted [very slow]
h. I selected correct column and found referenced table.
then I chose ‘no’ to run search option. [Imho results shall be the same]
Result: empty ;(
i. I tried to find how ‘apply lookup value’ works [i do not understand idea of such solution for DD diagram. ;(]
I followed instruction [selected required columns [after fiew tries]] and… get
following error ;(