Unable to Update Table Even After Dropping Constraint

[geoffrobinson]

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]

are there any triggers involved?

[geoffrobinson]

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

thanks,
Geoff

[geoffrobinson]

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