Posted by geoffrobinson on 10/03/92 11:37

In Microsoft SQL Server, I have a documents table and a table which
categorizes the documents, which we'll call categories.

I tried running UPDATE statements on the categories table previously
and I ran into a foreign key constraint. The error given was "UPDATE
statement conflicted with COLUMN REFERENCE constraint FK..."

So I got rid of the Foreign Key relationship, and tried running an
UPDATE statement against the categories table again.

I'm now getting the following message:
'Cannot UPDATE "categories" because "documents" exists.'

There must be something hanging around maintaining that relationship,
but I'm not sure where it would be found.

I was thinking about dropping the table and then adding it back again,
but I'm not entirely sure what that would do.

Any help is appreciated in advance.

thanks,
Geoff

• Next in forum: Truncated Decimals
• Prev in forum: Re: Newbie
• Thread view: Unable to Update Table Even After Dropping Constraint

[Reply to this message]