I have a table called TableX. I'd like to use SQL to create a copy of it.

Example:
create table TableXBU select * from TableX;

or

create table TableXBU like TableX;
insert into TableXBU select * from TableX;

Unfortunately none of these work. Is there a simple SQL alternative to copy a table?
TIA
Dave

"Dave" <dbguy@2-mail.com> wrote in message
news:12F68EE7-3747-4F56-8B76-0114ADDA9D76@news.elevatesoft.com...
>I have a table called TableX. I'd like to use SQL to create a copy of it.
>
> Example:
> create table TableXBU select * from TableX;
>
> or
>
> create table TableXBU like TableX;
> insert into TableXBU select * from TableX;
>
> Unfortunately none of these work. Is there a simple SQL alternative to
> copy a table?

SELECT INTO - but it will not copy the indexes, you need to add the
appropriate create index.

Robert

"Robert" wrote:


"Dave" <dbguy@2-mail.com> wrote in message
news:12F68EE7-3747-4F56-8B76-0114ADDA9D76@news.elevatesoft.com...
>I have a table called TableX. I'd like to use SQL to create a copy of it.
>
> Example:
> create table TableXBU select * from TableX;
>
> or
>
> create table TableXBU like TableX;
> insert into TableXBU select * from TableX;
>
> Unfortunately none of these work. Is there a simple SQL alternative to
> copy a table?

SELECT INTO - but it will not copy the indexes, you need to add the
appropriate create index.

Robert


Robert,
   The "select Into ..." is what I'm looking for. Thanks.

Dave