Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Edit Foreign Key Relationships

Author  Topic 

multiplex77
Starting Member

24 Posts

Posted - 2007-02-05 : 01:00:52
Hi,

I'm using SQL Server 2005 Management Studio. I've created several Foreign Key Relationships using Database Diagrams. Now I'm trying to edit the constraints on the relationships, but when I right click on the relationship, the only option available is "Delete Relationships from Database". But I am not able to edit the relationship. Does anyone know how to do this?

Thanks for the help.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-05 : 01:04:38
i don't think you can edit it. You can only DELETE then ADD


KH

Go to Top of Page
   

- Advertisement -