Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 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 May 10th, 2005, 09:35 AM
Friend of Wrox
 
Join Date: Mar 2005
Posts: 264
Thanks: 0
Thanked 0 Times in 0 Posts
Default How apply cascade update/delete in sql server ?

Hi experts. I got a small db in sql 2000 server that i imported it from access 2000 db.(6 tables). Unfortunetly i lost the reletionship between tables in this process! i wonder how i can add these table reltionsship back to sql server db and alos cascade delete/update to this sql server db ?

Furthermore, is there any way to view the table reltionshiip in sql server 2000 like access 2000?

I be happy if some one help me here since i am new to sql server and the whole db design.Thanks


This is a picture of my db reltionship:

http://i5.photobucket.com/albums/y18...letionship.jpg

 
Old May 10th, 2005, 10:22 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

A database diagram will work well for what you want to do (Use Enterprise Manager):

Go to Diagrams under the database you are using. Right click and choose create new diagram.

Use the tool bar, or right click menu to add the tables you want(Looks like 6 from your diagram).

If you have all your keys set up, you can drag and drop (column to column) to create your relationship. In there you can also specify cascading Update, Deletes etc.

Let me know how you do and if you need more help.
 
Old May 14th, 2005, 12:02 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 224
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to ashu_from_india Send a message via Yahoo to ashu_from_india
Default

hi

u can use SQL Server Enterprise Manager
its interface is like Ms Access
use the Relationship Tab to add/delete relationships






Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 2005 Delete on cascade DarkForce SQL Language 0 October 11th, 2008 08:24 AM
Similar Delete Cascade prasanna.nadgir C# 6 August 28th, 2007 04:12 AM
using VBA to implement cascade update~~~HELP bbqlee Access 2 August 7th, 2006 02:04 AM
How to apply the code of book on sql server? sharking BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 15 May 1st, 2006 10:20 AM
Urgent: Implement Cascade Delete through Code rcmetta BOOK: Professional Crystal Reports for VS.NET 0 June 7th, 2004 12:49 AM





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