Thanks to Simon for showing me how to find the remaining dependencies.
Strange, I got back eight rows and the error complains of six items.

That said, why is the column being deleted instead of being altered?
The underlying data type is not changing. Fixing the other dependencies
may be practically impossible.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Friday, February 17, 2006 12:15 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Can't alter column type

I'm trying to alter this table column
RECREATE TABLE PBM_CLAIM (..., MULTSRCCDE CHAR(1) NOT NULL COLLATE
ISO8859_1);

To this domain
CREATE DOMAIN D_MULTISRC AS CHAR(1) CHECK (VALUE IN ('M','O','N','Y'))
COLLATE ISO8859_1;

With this command
ALTER TABLE PBM_CLAIM ALTER COLUMN MULTSRCCDE TYPE D_MULTISRC

And I get this error

ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
cannot delete
COLUMN RDB$2133
there are 6 dependencies

I can't find any dependencies, and I don't know where to go from here.
Any ideas?

Thanks, Rick DeBay