Power Query Sql Database Relationships

[kersplash]

I am connecting to an sql database using power query and fumbling my way through the 400+ tables contained within by using the table previews.

Is there a nice way of looking at an overview of all the database tables AND their relationships?

I'm at home so can't try it now, but just getting ideas for tomorrow.

[mrice]

If you have access to Oracle's SQL developer, you can use import data dictionary to visualise the tables and the foreign key relationships. Other database navigators will probably have something similar.

[kersplash]

Thanks Martin.

I have SQL Server Management Studio 2012.

There is a Database Diagrams folder in Object Explorer, but looks like I don't have the right access.

Capture.JPG

[Kyle123]

They probably haven't made any diagrams. You can do it in visual studio, never used it, but if you have Viso, I believe that you can generate db model diagrams in that too

[kersplash]

You're right. IT tells me no diagrams created. I can view the table dependencies though in the object explorer so that may have to do for now.