Phantom Foreign Keys (Cannot Delete)

[lipmanc]

I have a couple of data model tables and created an association between, which generated a foreign key in the format FK_SourceTableName_TargetTableName.  Usually, if I delete the association, the foreign key is dropped as well; however, every once in a while it does not drop and if I try to  recreate the association, it says a FK with this name already exists.  (I could just give it another name, but I don't know why the original FK remains.)

I know I can delete the FK from the Operations dialog but it warns me that continueing could cause inconsistencies (and recommends that I use the FK dialog).

Why does the phantom FK remain and how do I determine whether there will be any issues if I forcably delete it from the Operations dialog?

[thomaskilian]

I eventually had the same problem with code transformation. I just remember that I started clicking/deleting around until it was okay again. It did not happen very often and I claimed it to me making wrong transformation code.

[lipmanc]

Thanks, but I'm not doing anything with transform code (to my knowledge).  

My DLL ported out to SQL Server okay.  I just hope that I don't have a referential integrity issue that's going to haunt me in the future (either in the implementation or even while modeling within EA).

[thomaskilian]

Sometimes it helps to run the integrity check (Tools/Data Management). I have no better advice :-/