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.
| Author |
Topic |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2006-10-30 : 00:08:08
|
| Hi all, SQL server allows to create as many as foreign key constraints on a same table for a same column. Will this affect the design or performance in anyway ?Naming the constraint would be a good way to avoid this.But in case if someone has already created, How do I remove the existing duplicate keys ?======================For Example , I have 2 tables Author and Book. I could execute the below query n times and create as many as foreign keys I want.ALTER TABLE Books ADD FOREIGN KEY (AuthorID) REFERENCES Authors (AuthorID) ======================Thanks is advance,HHA |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-30 : 08:37:52
|
Why dont you:1) Try it and find out?2) Read BOL (Books OnLine) and see what it says about Foreign Key Constraints.Make sure you backup your database first.  [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
Duplicate foreign keys.