Wrox Programmer Forums
SQL Server 2008 General discussion of SQL Server *2008* version only - not related to a specific book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2008 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 11th, 2010, 07:30 PM
Authorized User
Join Date: Feb 2008
Posts: 89
Thanks: 13
Thanked 0 Times in 0 Posts
Smile Simple Question

See following picture,

Learn me how to view that page in SQLserver and how to construct those relationships between them?

Last edited by msman88; April 11th, 2010 at 08:14 PM..
Old May 30th, 2010, 09:11 AM
Authorized User
Join Date: Mar 2006
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts

The diagram you attached is a snapshot of SQL Server Diagram.
In Management Studio -
1. Click your database in left pane.
2. Click Database Diagrams. (A pop-up will appear for table creation- accept that)
3. Right Click Database Diagram > New Database Diagram.

A window appears about tables to be included. If relation is already there- you can see the relation. You can create relationships (Foreign keys, Primary keys etc.).
-Som Dutt

Similar Threads
Thread Thread Starter Forum Replies Last Post
simple question petergoodman XSLT 8 July 18th, 2008 07:57 AM
very simple question rogdawg Visual Studio 2005 2 January 14th, 2008 04:03 PM
Very Simple Question YoungLuke C# 2 May 4th, 2007 02:23 AM
Simple Question ironchef Java GUI 0 September 14th, 2006 04:56 PM
Simple Question JEHalm BOOK: Beginning Access VBA 0 December 29th, 2005 10:42 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.