Re: copy a table

From: "Robert Klemme" <bob.news@xxxxxxx>
Date: Thu, 23 Feb 2006 14:53:20 +0100

Marcin Zmyslowski wrote:

Hello all!

How to copy a table in MS SQL Server 2000 without chaning a
structure? I mean, I have one table, which has autoincrement numeric
field (ID). When I copy this table by exporting this table into the
same database folder I loose the specification of the field ID. Now
it is not autoincrement field but usual int field. Is it possible to
copy this table without changing data and structure of a table?

With DTS copy object might do the trick. Otherwise, create DDL with QA or
EM, create the new table and then copy the data with "SET IDENTITY_INSERT
your_table ON". HTH

robert

.

Follow-Ups:
- Re: copy a table
  - From: Madhivanan

References:
- copy a table
  - From: Marcin Zmyslowski

Prev by Date: copy a table
Next by Date: Re: Loop / Cursor help
Previous by thread: copy a table
Next by thread: Re: copy a table
Index(es):
- Date
- Thread

Relevant Pages

Re: DirectoryServices
... >This sounds rubbish to be frank. ... Yes, why would you want to redundantly store user name, e-mail and ... such AGAIN in SQL Server, if that's already available in your AD?? ... changing data *IS* indeed the way to go! ...
(microsoft.public.dotnet.framework)
Re: Upsize and performance
... deleting of fields from a table) back when I was evaluating SQL Server. ... work with the database or Access. ... Unused objects only take up a negligable amount of memory. ... you're talking about changing data in the SQL Server tables, ...
(microsoft.public.access.modulesdaovba)
Re: Upsize and performance
... I am referring to adding a fieldto a table via SQL Server Manager. ... Unused objects only take up a negligable amount of memory. ... you're talking about changing data in the SQL Server tables, ... when I change the SQL database tables the change is not reflected in Access ...
(microsoft.public.access.modulesdaovba)