|
Author:
Author Bio:
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.
|
|
|
Creating a Database Diagram in SSMS
Database diagramming is useful, especially when you're new to a dabase, but it has a few quirks. Well known speaker and trainer Brian Knight demonstrates how to enable database diagrams, how to use them to manage foreign keys, and more!
|
Video Information
|
Publish Date:
|
December 01, 2008
|
Length:
|
5:36
|
Skill Level:
|
100
|
Rating:
|
4.34 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- What happens if you remove a line indicating a foreign key relationship?
- What steps are needed to show existing foreign key relationships in a database diagram
|
Watch Video Now! Watch it later! Take Quiz For Video Now!
|
|
|
|
|
|
Comments:
|
|
i already new the basics, looking for advice on arranging diagram and printing diagram.
|
|
|
I know you said it, but I think a much stronger warning should be made that the diagram is tied to the database definition. If someone is just trying to create a pretty diagram, there is much too much danger that all sorts of constraints and such will be introduced "automagically".
But nice job...
|
|
|
I learned a few new things - thanks!
|
|
|
I have been looking for this feature for 7 months now!! Thank you, Thank you. I'm so used to looking at ERD Charts for relationships.
|
|
|
What a powerful tool. I had no idea that diagrams could be used to design the db as well.
|
|
|
He says: "It's not quite as good as Visio or ERWIN"... Ya think?
|
|
Sara Karasik on 10/21/2009
Way too basic.
|
|
|
|
|
|
|