Toad World® Forums

Database Diagram: 9 issues


#1

Hi.
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
tables.
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
selected]

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
a.]

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 ;(


Butter

int_1.jpeg

int_2.jpeg

int_3.jpeg

int_4.jpeg
int_1.jpeg


#2

Hi Motyl,

I’ve created CR81703 for further investigation.

regards,

Alexander Maximov
int_1.jpeg


#3

Hi Motyl,

I’ve created CR81703 for further investigation.

regards,

Alexander Maximov
image002.jpeg


#4

Hi Motyl,

I’ve created CR81703 for further investigation.

regards,

Alexander Maximov
int_4.jpeg


#5

Hi Motyl,

I’ve created CR81703 for further investigation.

regards,

Alexander Maximov
int_3.jpeg


#6

Motyl,

Here is the status of your Database Diagram requests:

Attachment not added (general error): “image004.jpg”
image002.jpeg


#7

Motyl,

Here is the status of your Database Diagram requests:

Attachment not added (general error): “image004.jpg”


#8

Motyl,

Here is the status of your Database Diagram requests:

Attachment not added (general error): “image004.jpg”
int_1.jpeg


#9

Motyl,

Here is the status of your Database Diagram requests:

Attachment not added (general error): “image004.jpg”
int_3.jpeg