Re: Remove Foreign Key

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 30 Jul 1999 19:20:06 +0800
Message-ID: <37A18A65.5138@yahoo.com>

Shelli D. Orton wrote:
>
> Hi,
>
> I've set up a table with a foreign key and its now causing me
> headaches. Can someone tell me how to remove a foreign key reference
> from a table?
>
> Thanks in advance,
> Shelli

select * from user_constraints
where table_name = 'MY_TABLE'
and constraint_type = 'R'

gives you the foreign key names...

alter table MY_TABLE drop (or disable) constraint <constraint_name>

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Jul 30 1999 - 06:20:06 CDT