Unable to Update Table Even After Dropping Constraint

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

are there any triggers involved?

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

thanks,
Geoff

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