Database data diagram


I got customer who want to create a data diagram for the table inside MSSQL. He want complete picture how 1 table relate to another table.

Question : can toad able to do this ? Automatically draw the relation from one table to another table.


Toad for SQL Server has a 'Database Diagram' feature that shows the relationships between tables.
To invoke that feature:

  • Right click on a table and select 'Send To - Database Diagram'
    Once that tab is open there is a control at the top that allows you to control how many levels of relationships (RI) will get displayed. That control is highlighted in the image below.

Hope this helps