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 |
|
Jillsy
Starting Member
20 Posts |
 Posted - 2006-02-02 : 13:59:27
|
| I've noticed that some of my tables have primary keys that are not referenced by a foreign key in another table, is this indicative of bad design?Jill |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-02 : 14:01:03
|
| No. Some tables will not have any references to other tables.Tara Kizeraka tduggan |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-02-02 : 14:09:18
|
| >>is this indicative of bad design?Not necessarily. But if that primary key is "associated" to column(s) in another table then you could be missing referencial integerity without a foreign key. I guess the question to ask is if you delete a row from your table will that result in orphaned rows in other tables?Be One with the OptimizerTG |
|
|
|
|
|
|
primary key