On Tue, 21 Jan 2003, jerome wrote:
> i was wondering is it possible to drop column refereces from tables without
> droping the table...
Yes, although prior to 7.3 it was difficult.
To remove a references constraint in 7.2 and below, you need to find the
three triggers that make up the constraint (1 on the table with the
constraint, 2 on the table that the constraint references) and drop them.
In 7.3, you can use alter table drop constraint I believe.