Database data diagram

Toad for SQL Server Idea Pond
1

Hi,

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.

Thanks.

2

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.

image
image.png748×456 50.5 KB

Hope this helps