Creating new table by copying contents from another table

• Smruti-255597

  Old Hand

  Points: 301

  More actions

  August 26, 2005 at 4:16 am

  #89586

  Write the query to create table by copying the contents from another table

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  August 26, 2005 at 4:41 am

  #585321

  SELECT * INTO newtable FROM oldtable

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 26, 2005 at 6:26 am

  #585341

  Why do you want to do that?