Re: ignoring constraints

Rafe,
  if you wan't to drop B the only way is to drop the   constraint before you drop the constraint (otherwise   the constraint would point to a non-existing object).

  If you just want to delete/truncate the rows in B   you can DISABLE the constraint.

Regards
Dante
In article <373648CC.B4FA7B05_at_rc3.org>,   Rafe Colburn <rafeco_at_rc3.org> wrote:
> Is there any way to ignore integrity constraints for a particular
> query? For example, let's say I've created a foreign key relationship
> between two tables, A and B. Is there any way to ignore that
> relationship so that I can drop table B without first deleting all the
> interdependent records? I run into a similar problem with
>
> DELETE FROM B
>
> and
>
> TRUNCATE TABLE B
>
> Also, can anyone tell me the syntax used to remove constraints from
> tables using the ALTER TABLE command?
>
> Finally, is there any easy way to view the constraints on a table
using
> SQL*PLUS?
>
> Thanks.
>
> --
> Rafe Colburn . . . . . . . . . . . . . . . . . rafeco_at_rc3.org
> Outraged! Daily Edition . . . . . . . . . . . http://rc3.org
> Teach Yourself CGI in a Week . . . . . http://rc3.org/cgibook
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 10 1999 - 03:48:02 CDT