Toad World® Forums

Want to know related table with other table


#1

I’m too beginning to learning TOAD.

How do I know table “A” have related with table “B” at schema browser ?.I want to change simple data from table “A” but i’ not sure whether it’s related with other table

Can you assist me on this.

table.doc (76 KB)


#2

The easiest way is to double-click on the table in the Object Palette while you are on the UNDERSTAND tab. Double-clicking will bring in Table A and all of the tables that are related to it in the database.

The relationship must exist at the database level, not at a logical level.