Professional Web Applications Themes

Copy a table? - Microsoft SQL / MS SQL Server

select * into newtablename from oldtablename or if the table is already created insert into newtable(allcols1,allcols2.....) select * from oldtablename (notice the lack of parenthesis in the values area) "Polaris" <com> wrote in message news:phx.gbl... ...

Sponsored Links
  1. #1

    Default Re: Copy a table?

    select * into newtablename from oldtablename

    or if the table is already created

    insert into newtable(allcols1,allcols2.....) select * from oldtablename

    (notice the lack of parenthesis in the values area)


    "Polaris" <com> wrote in message
    news:phx.gbl... 


    Sponsored Links
    webamster@gregbates.com Guest

  2. #2

    Default Re: Copy a table?

    Polaris,

    --With data but no constraints and indexes
    SELECT *
    INTO <newtable>
    FROM <oldtable>

    -- just structure no data
    SELECT *
    INTO <newtable>
    FROM <oldtable>
    WHERE 1=2


    --
    Dinesh.
    SQL Server FAQ at
    http://www.tkdinesh.com

    "Polaris" <com> wrote in message
    news:phx.gbl... 


    Dinesh.T.K Guest

  3. #3

    Default Copy a table?



    Aaron Guest

  4. #4

    Default Re: Copy a table?

    Is there anyway to copy over the "Default" value settings
    when using Select * into newtablename from oldtablename?

    Thanks in advance,

    Frank Cheng

    "com" <com> wrote in message
    news:#phx.gbl... 
    >
    >[/ref]


    Frank Guest

  5. #5

    Default Re: Copy a table?

    Sorry, my post was just to knock the original post down (it was post-dated).



    "mark baekdal" <com> wrote in message
    news:070c01c34c2a$6e9bd670


    Aaron Guest

Similar Threads

  1. copy table
    By xixi in forum Coldfusion Database Access
    Replies: 1
    Last Post: February 17th, 08:11 AM
  2. How to get Table Parameters to copy table
    By Joe in forum ASP Database
    Replies: 5
    Last Post: November 29th, 12:13 AM
  3. Copy Table Via OCI
    By Dale in forum Oracle Server
    Replies: 0
    Last Post: September 8th, 10:02 AM
  4. Copy a table
    By Frank in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 14th, 04:26 PM
  5. Copy data into same table
    By Johny in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 13th, 05:19 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139