Duplicating tables/defaults/settings within same database

[WolfShade]

Hello, all.

I have an MS-SQL database (I think it's SQL Server 2000 or 2003) that I would like to create duplicate tables with slightly different names, copy all the defaults/indeces/triggers and other settings, AND copy all the data, too.

Is there a way to do this without using a DTS?

Thanks,

^_^

[chazzy]

hmmm. only thing i could think of off the top of my head would be to take an export/backup and manually changing the names.