MS SQL Server comes with a function called Database Diagrams. You can use it to produce ERDs (Entity Relationship Diagrams).

Start by right clicking on Database Diagrams > New Database Diagram in the Object Explorer

If you get the following error, you database does not have an owner assigned.

To assign an owner, right click on your database name and select Properties

Under Select a page > Files – By Owner select … radio button> Browse

Select your user name from the list and then hit Okay until you are back to the main screen.

Right click Database Diagrams > New Database Diagram

Click Yes

Now select some tables. In this example, I am choosing Employee and SalesPerson

The diagram shows the tables you picked, and the data fields. It also shows connections.

Notice the tables do not all connect directly with each other. Another point to take note of is the small yellow keys located in from of some fields. These let you know that those fields are the primary key(s) for their respective table. The primary key is the unique identifier for the table.