Dupliate a Table

Results 1 to 2 of 2

Thread: Dupliate a Table

  1. #1
    Join Date
    Dec 1969

    Default Dupliate a Table

    Hi,<BR>I&#039;m using SQL Server and I wana know how to duplicate a table. I read the books online help on duplicating tables but I couldn&#039;t get it to work. Can someone help me out? Thanks - Trevor

  2. #2
    Join Date
    Dec 1969

    Default RE: Dupliate [sic] a Table

    SELECT * INTO duplicate_table_name FROM original_table_name<BR><BR>Or add conditions to copy only part of a table. Or or or.<BR><BR>http://msdn.microsoft.com/library/en-us/tsqlref/ts_sa-ses_1l4j.asp<BR><BR>

Posting Permissions

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