Posting Yak Master
Posted - 10/30/2006 : 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
FOREIGN KEY (AuthorID)
REFERENCES Authors (AuthorID)
Thanks is advance,