Thanks Mike. Luckily, I donĀ¹t need the data if the table already exists so
that should work.
Tony
On 10/11/06 2:53 PM, "Mike Morris" <[EMAIL PROTECTED]> wrote:
> My advice:
>
> Do a "drop table" first, ignoring any error that will result if it does not
> exist, then do the "select into". This
My advice:
Do a "drop table" first, ignoring any error that will result if it does not
exist, then do the "select
into". This is portable, too...
> I have a script that creates a table copy using SELECT INTO, but I want it
> to check if the new table already exists first. Does SQL support the E