Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brian226
Starting Member
2 Posts |
 Posted - 2007-02-01 : 14:01:42
|
| Hey, I have SQL Sever Enterpise Manager. I am new at this company and I need to know the relationships between ALL the tables. Is there anywhere I can go to view all the primary keys and the relationships? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-01 : 14:14:43
|
| Go to Diagrams in Enterprise Manager and have it diagram all of your tables. It will give you a visual way of seeing the relationships. If you want to see the actual code for the constraints, then you can right click on the database, go to All tasks, then to generate SQL script (on third tab, select option to script constraints).Tara Kizer |
 |
|
|
brian226
Starting Member
2 Posts |
Posted - 2007-02-01 : 16:53:01
|
| When I go in Diagrams it is blank. I use Everest for my gui and I'm not sure if that automatically creates the relationships as it's pulling the data. I would like to see everything in the background. Not sure if you can do that |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-01 : 17:00:02
|
| Of course it's blank as you haven't created the diagram yet. You must create it in order to see the relationships. To create a diagram, click on Diagrams, then in the right pane right click and select new database diagram.Tara Kizer |
|
|
|
|
|
|
Relationships