Search code examples
sql-serverax

How to see table relationships in database diagrams?

I have lots of tables and I know there are relationships between them because I can see some of them from Microsoft AX AOT. When I go to SQL server management studio and use database diagrams option I can add the tables I want but I cant see relationships? How can I see them?

Solution

  • If you're interested in table diagrams, and you have both AX 2012 and Visio installed, you can go to AX → Tools → Reverse engineer → Visio UML data model.

    Or just right-click an AX project with tables → Add-Ins → Reverse engineer.

    More info online: http://msdn.microsoft.com/en-us/library/aa499193.aspx