May 16, 2014 at 2:22 pm
Hi all,
Started a new job on Monday and I finally got access to development environment. Can anyone recommend a fast and efficient way to get used to the database environment? I know SQL has a database diagram, but when I try to join tables together, I get a message that asks if I want to commit the changes. Is there a way that I can see the relationships, joins, etc without committing? Or am I just not using the database diagram correctly?
Thank you all in advance,
Dave
The are no problems, only solutions. --John Lennon
May 16, 2014 at 2:33 pm
dmandosql (5/16/2014)
Hi all,Started a new job on Monday and I finally got access to development environment. Can anyone recommend a fast and efficient way to get used to the database environment? I know SQL has a database diagram, but when I try to join tables together, I get a message that asks if I want to commit the changes. Is there a way that I can see the relationships, joins, etc without committing? Or am I just not using the database diagram correctly?
Thank you all in advance,
Dave
The database diagram is a look at the actual tables including foreign keys. If you add them in the diagram tool they are being added to the database. If the tables in there do not have links that is a good indication that there are no foreign keys.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 16, 2014 at 2:40 pm
The database diagram tool is a lightweight data modeling tool. At least until you have a diagram created that matches your schema.
If you are trying to get a feel for the table relationships, you could use this script
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply