[EMAIL PROTECTED] (Vivek Khera) writes:
> > "DP" == David Parker <[EMAIL PROTECTED]> writes:
>
> DP> I would like to be able to truncate all of the tables in a schema
> DP> without worrying about FK constraints. I tried issuing a "SET
> DP> CONSTRAINTS ALL DEFERRED" before truncating, but I s
Vivek Khera <[EMAIL PROTECTED]> writes:
> "DP" == David Parker <[EMAIL PROTECTED]> writes:
> DP> I would like to be able to truncate all of the tables in a schema
> DP> without worrying about FK constraints. I tried issuing a "SET
> DP> CONSTRAINTS ALL DEFERRED" before truncating, but I still get
>
but maybe it
wouldn't be too difficult...
- DAP
>-Original Message-
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Vivek Khera
>Sent: Thursday, November 04, 2004 3:05 PM
>To: [EMAIL PROTECTED]
>Subject: Re: [GENERAL] disabling constraints
>
>
> "DP" == David Parker <[EMAIL PROTECTED]> writes:
DP> I would like to be able to truncate all of the tables in a schema
DP> without worrying about FK constraints. I tried issuing a "SET
DP> CONSTRAINTS ALL DEFERRED" before truncating, but I still get
DP> constraint errors. Is there a way to d
I would like to be able to truncate all of the tables in a schema without worrying
about FK constraints. I tried issuing a "SET CONSTRAINTS ALL DEFERRED" before
truncating, but I still get constraint errors. Is there a way to do something like:
1) disable all constraints
2) truncate all tables
3
