www.webdeveloper.com
Results 1 to 2 of 2

Thread: copy table

Hybrid View

  1. #1
    Join Date
    Mar 2006
    Posts
    8

    copy table

    hey
    if i want to copy a table into totaly new table(that not created yet)

    if i use the followin statement
    create table studentcopy select * from student
    i receive that there is error near 'select'

    if i want use the following statement

    insert into table studentcopy select * from student
    in this case i got error that studentcopy table doesnot exist

    i use MS SQL

    how can i copy table to new table

    if it is not possible and i have to create empty table first before
    copying the content from the other table, then how can i return the structure of the original table to creat same table exactly
    (mean how can i get the info of how the student table is created using qury)

    thx

  2. #2
    Join Date
    Mar 2006
    Location
    NCAA Tournament Hell
    Posts
    21
    If your using SQLServer 2000 then you could use the DTS you could select your source database then select the same database for its destination. When importing a copy of your table, you must rename it...

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