Duplicating tables/defaults/settings within same database
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?
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)