Hi,

I just deleted a bunch of FKs from QA (click table name, then constriant, and delete the FK__ ones). But when I tried to recreate them, it keep complains that the new FK conflicts with the old ones (which I should have deleted). And when I check sysconstraints table, the old ones were not shown there.

So obviously, the old FKs were still kept somewhere. How do I delete them completely so I can put the new ones on?

Thanks,

Elaine





MS Sql Server LazyDBA home page