copyind data and indexes

Hi everyone!
How can I do to copy the data and the indexes from an existing table on a
database to a new table in another database?
I've tried with select * into base1.table1 from base2.table2, but it only
copy the data and not the indexes.
Can I do it by code? I'm trying to avoid the use of DTS.
Thanks.
Jaime LucciIn Query Analyzer you can auto-script the index for a table and apply
that to the newly created table
HTH,
Gerard|||How can I auto-script the index?
"Gerard" <g.doeswijk@.gmail.com> wrote in message
news:1132151890.279793.213110@.f14g2000cwb.googlegroups.com...
> In Query Analyzer you can auto-script the index for a table and apply
> that to the newly created table
> HTH,
> Gerard
>|||In Query Analyzer: Expand the Indexes folder on the table, select the
index you wish to script and right click on it and the rest will show
it self
NB:
You will have to replace the table name in the created script to apply
it to your other table