April 19, 2011 at 3:28 pm
On our production box, I found a couple foreign keys that is referencing itself. Something like this:
ALTER TABLE [Out].[Participations] ADD CONSTRAINT [FK_Participations_Participations] FOREIGN KEY ([ParticipationID]) REFERENCES [Out].[Participations] ([ParticipationID])
My first guess was that this just silly. But perhaps there's a reason for this?
Thanks!
-Kevin
April 19, 2011 at 4:19 pm
It looks like a misapplication of the Parent/child relation being in the same table. I'm not entirely sure why you'd ever do that.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 19, 2011 at 4:37 pm
Thanks Craig. I needed someone to reassure me that there isn't something obvious I'm missing.
April 19, 2011 at 4:41 pm
kevin.wu (4/19/2011)
Thanks Craig. I needed someone to reassure me that there isn't something obvious I'm missing.
No problem. Sometimes a quick sanity check is a nice thing when you're running Lone Wolf.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply