Knowing ERD for Joins and Subquerries

Question

Post reply

Knowing ERD for Joins and Subquerries

pietlinden

SSC Guru

Points: 63621
More actions
January 16, 2022 at 2:31 pm
Answer
#3973666

https://www.biinsight.com/how-to-share-a-sql-server-database-diagram-with-others/#:~:text=First%20of%20all%20you%20should%20install%20diagram%20support,Now%20you%20are%20able%20to%20create%20your%20diagrams.

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63621 More actions · Answer 1

pietlinden

SSC Guru

Points: 63621

January 15, 2022 at 11:27 pm

#3973550

Look at the database diagram?

protocoder Old Hand Points: 374 More actions · Answer 2

No I don't see them for the sample database I have restored or the built-in INFORMATION SCHEMA

protocoder Old Hand Points: 374 More actions · Answer 3

@pietlinden Thank you very much. I will work on this. Is my thought process correct that I understand the ERD before working on these database-related questions on joins, sub querries, CTEs and Window Functions

pietlinden SSC Guru Points: 63621 More actions · Answer 4

Understanding what the different tables describe helps a lot. You don't necessarily have to understand the entire diagram, just the part(s) you're going to use.

Johan Bijnens SSC Guru Points: 135590 More actions · Answer 5

Ask for "view definition" to be granted to you, so you can seed an objects composition.

GRANT view definition TO [user_or_role]

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data and code to get the best help

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me