Re: Copying a table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Wed, 24 Jun 2009 00:03:10 +0100, John wrote:


Hi

How can I make an exact copy of a table with indexes, constraints and all?

Thanks

Regards

Hi John,

You already asked that same question in a different group
(microsoft.public.sqlserver.newusers) yesterday, and you have already
received several good replies there.

So why did you repeat the question here?

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

Relevant Pages

  • Re: Unique index not recognizing null
    ... if they're not subject to the constraints of the Index?" ... consistent with other products - including SQL Server, Oracle, and how MS ... value in one or more of the key fields will not be included in the ... Nulls setting made no difference. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
    ... > I read SQL Server MVP Louis Davidson's post saying: ... > Constraints are the standard way to do this, and really should be the way ... > Even I read in the Microsoft SQL Server Introduction (SQL 7 book ... > DefaultZero ...
    (comp.databases.ms-sqlserver)
  • Re: Disabling Constraint for Bulk Loading
    ... I am working on ASE 12.5 ... Are you using Sybase SQL Server or Microsoft ... to disable constraints the command is NOCHECK CONSTRAINT ALL. ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server error when attempting to delete a record
    ... What version of SQL Server have you got? ... recordto be affected and execute this command based on the Primary Key ... Script the table's definition to a file (including constraints, indices, ... of the database, factors like that. ...
    (microsoft.public.sqlserver.server)
  • RE: How to narrow down the failure message
    ... ISDATE() is not 100% foolproof. ... SQL Server agent in the tree on the left of SSMS, and open it up and expand ... Is there any way to make a Failure ... statement pinpoint the exact item that caused the failure? ...
    (microsoft.public.sqlserver.server)