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

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.

hi

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