Had a question about database diagrams.
We want to set up a diagram to mainly get the benefit of visualizing our data, and establishing the relationships. The tables we have are old and do not always have a simple key.
The diagram seems like a good fit, but does anyone know if we can set it up so that the relationships set up in the diagram do not enforce any rules or effect the tables the reference in any way? We don't want to effect the tables, only get a layout of the data we have.
Is there a better tool to use outside of Management Studio 2008 R2 to set up these relationships for visualization only?
Any help would be appreciated!