Results 1 to 2 of 2

Thread: Duplicating tables/defaults/settings within same database

Hybrid View

  1. #1
    Join Date
    Dec 2002
    St. Louis, MO, USA

    Duplicating tables/defaults/settings within same database

    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?



  2. #2
    Join Date
    Aug 2005
    The Garden State
    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.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center

Recent Articles