Visualizing Database Schema
In SSMS you can easily create diagrams showing the relationships between tables. The basic steps are:


Connect to the database server
Expand the Databases folder
Expand the folder for the database you're investigating.
Right click on the Database Diagrams folder.

a. Select Install Diagram Support if needed
Select New Database Diagram
In the wizard add any tables you're interested in.
Take the appropriate next step:

a. Curse the previous DBA/Developer that generated this mess.

b. Thank your deity of choice for the blessing of a well structured/modeled database.

c. Shrug your shoulders and tell yourself this is manageable.