ignoring constraints

From: Rafe Colburn <rafeco_at_rc3.org>
Date: Sun, 09 May 1999 22:47:40 -0400
Message-ID: <373648CC.B4FA7B05@rc3.org>

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 Received on Sun May 09 1999 - 21:47:40 CDT