Microsoft SQL Server forum - Unable to Update Table Even After Dropping Constraint

Author

Unable to Update Table Even After Dropping Constraint

geoffrobinson

2006-01-16, 8:24 pm

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

Alexander Kuznetsov

2006-01-16, 8:24 pm

are there any triggers involved?

geoffrobinson

2006-01-16, 8:24 pm

I looked for them, but I didn't see any. I will take another look.

thanks,
Geoff

geoffrobinson

2006-01-19, 11:23 am

Alexander Kuznetsov wrote:
> are there any triggers involved?

It was indeed triggers. I just didn't see them there or didn't think
about it. I'm not sure what mistake I made.

At any rate, thank you.

Geoff

Sponsored Links