Re: Any way to "conditionally" drop a table?

From: Scott Watson <nospam_at_hotmail.com>
Date: Mon, 27 Oct 2003 23:21:53 -0500
Message-ID: <i6mnb.33666$Pt3.1025396@weber.videotron.net>

Because that is what he needed to do. Surely, it is not too hard to figure out that you need to wrap the drop table command inside an execute immediate clause.

Besides I said execute something like this NOT execute this.

I will try to be more precise in the future.

Scott Watson.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1067304888.881013_at_yasure...
> Scott Watson wrote:
>
> >Try creating a callable statement and then execute something like the following.
> >
> >"begin drop table tablename cascade constraints; exceptions when others then null; end;"
> >
> >Hth
> >Scott Watson.
> >
> >
> >
> Did you try this before you suggested it?
>
> And in answer to that rhetorical question ... why did you post it?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon Oct 27 2003 - 22:21:53 CST