SQL Server Performance Forum – Threads Archive

FK error

I get the following error when trying to add a FK reference: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint ‘FK_tblTrading_Indices_Constituents_tblTrading_Indices’. The conflict occurred in database ‘database2’, table ‘tblTrading_Indices’, column ‘Index_Code’. I checked. That FK does not exists. Just to be safe I tried dropping it and no luck. I added a UNIQUE constraint on Index_Code in the table being referenced. Both Index_Code cols in each table are same datatype. Suggestions are appreciated.

No replies? Can someone help? Thanks.

quote:Originally posted by photura I get the following error when trying to add a FK reference: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint ‘FK_tblTrading_Indices_Constituents_tblTrading_Indices’. The conflict occurred in database ‘database2’, table ‘tblTrading_Indices’, column ‘Index_Code’. I checked. That FK does not exists. Just to be safe I tried dropping it and no luck. I added a UNIQUE constraint on Index_Code in the table being referenced. Both Index_Code cols in each table are same datatype. Suggestions are appreciated.

Are you looking at just two tables? There may be a third table involved. This will tell you the name of the table on which your constraint FK_tblTrading_Indices_Constituents_tblTrading_Indices is defined: SELECT OBJECT_NAME(s.id)
FROM dbo.sysconstraints s
WHERE s.constid =
OBJECT_ID(‘FK_tblTrading_Indices_Constituents_tblTrading_Indices’)

Also run sp_fkeys ‘parentTable’ to know all child tables Madhivanan Failing to plan is Planning to fail

<pre id="code"> sp_fkeys ‘parentTable' </pre id="code"> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

I just edited the reply Frank. As usual you are faster [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Madhivanan Failing to plan is Planning to fail

I really like the RSS feed. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by FrankKalis I really like the RSS feed. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a> Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <hr height="1" noshade id="quote"></blockquote id="quote"> I havent tried it yet though I am willing to use it [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Madhivanan Failing to plan is Planning to fail

I don’t have any idea. I ran your statement below and it returned a blank row. I also ran the sp twice with each table name as the parent table and it also returned a blank row. Then I tried running the FK statement again: ALTER TABLE tblTrading_Indices_Constituents ADD CONSTRAINT FK_tblTrading_Indices_Constituents_tblTrading_Indices FOREIGN KEY (Index_Code) REFERENCES tblTrading_Indices (Index_Code) and it still returns the same error: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint ‘FK_tblTrading_Indices_Constituents_tblTrading_Indices’. The conflict occurred in database ‘dfasys2’, table ‘tblTrading_Indices’, column ‘Index_Code’. Help! <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Adriaan Are you looking at just two tables? There may be a third table involved. This will tell you the name of the table on which your constraint FK_tblTrading_Indices_Constituents_tblTrading_Indices is defined: SELECT OBJECT_NAME(s.id) FROM dbo.sysconstraints s WHERE s.constid = OBJECT_ID(‘FK_tblTrading_Indices_Constituents_tblTrading_Indices’) <hr height="1" noshade id="quote"></blockquote id="quote">

did you check if all the data in the child is in the parent table? May the Almighty God bless us all!
www.empoweredinformation.com

]]>