Foreign key constraint question

[Perry Smith <pedz@xxxxxxxxxxxxxxxx>]

I want to do something like this:

ALTER TABLE companies ADD CONSTRAINT fk_companies_item_id

             FOREIGN KEY (item_id, 'Company')

             REFERENCES item_bases(item_id, item_type)

             INITIALLY DEFERRED

I could add a column to companies that is always set to "Company" but that seems like a waste.  I tried the above and I got a syntax error.

Any suggestions?

Thank you,

Perry Smith ( pedz@xxxxxxxxxxxxxxxx )

Ease Software, Inc. ( http://www.easesoftware.com )

Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems