Create a Copy of Any Table With Data in SQL Server

Hi Vipendra,


If we want to copy the structure as well as records

select * into newtable from oldtable

SELECT  *
INTO  employee1
FROM  employee



Thanks