@konrob

The solution offered by RatBak works.  You can change options and have the diagrams shown in data diagrams views contain datatypes and if they are nullable.  I haven't...

Thank you, Gentlemen.

That helps a lot.

Jeff, I've spent a few hours watching YouTube videos on SSMS since reading your response.  I had tried that when I first got SSMS installed and working a bit for...

Jeff, again, I cannot thank you enough for this kind of help.  I truly appreciate the time and effort you put into helping me.

You've given me lot to chew on. ...

Thanks for the response, Jeff.

In answer to your questions:

1. Yes, I know about and have used Object Explorer in SSMS. I created my databsase and its tables using it; however,...

Thank you, Chris.  That helps immensely.

I investigated and found that my queries were saved in the Documents folder accessible from File Explorer.  Is that because they are basically text files? I suppose that to be...

If you go into Tools - Options, you will see import/export. That's the file to change. Mine is in VS 2015/Settings/SSMS. Change the ProjectsLocation key. However, do this when...

If you go into Tools - Options, you will see import/export. That's the file to change. Mine is in VS 2015/Settings/SSMS. Change the ProjectsLocation key. However, do this when...

Thanks, Jeffrey.

I have made it a practice to right click tabs in SSMS windows and choose Save filename.  I haven't paid much attention to the pathname.  You've given another lesson. ...

Thank you, Gentlemen!

Good to know about deprecations.  That information doesn't show up  in all search results.

Thanks, again, Chris.

Thanks, Chris.

I am still having problems with relationships.  I make them and save the diagram, but when I return the relationship indicators are gone.

I did not have to run the...

Thanks for the response ratbak.

The design might indeed be poor as I am very inexperienced with RDBMS, being an old (83) COBOL programmer accustomed to flat files.

I chose to create...

• This reply was modified 1 month ago by  Ahr Aitch. Reason: Clarifying and adding information
• This reply was modified 1 month ago by  Ahr Aitch.

OK, after closer inspection I found that I could reveal more information about keys (ss below), but it adds to my confusion.  All of the keys seem to reference the...