How to create a reflexive relationship (Enterprise Manager)

To create a reflexive relationship

1. Open a database diagram.
2. Click the row selector for the database column that you want to relate to another column.
3. While the pointer is positioned over the row selector, drag the pointer outside the table until a line appears.
4. Drag the line back to the selected table.
5. Release the mouse button.

   The Create Relationship dialog box appears and attempts to match the primary key columns with the non-key columns you dragged the line to.

6. Confirm that the columns you want to relate are shown in the Primary key table and Foreign key table lists.

See Also