Follow by Email

Monday, 24 June 2013

Create a duplicate table from another table in Sql

Here is simple Sql query to achieve this:

SELECT * INTO NewTab FROM  AlreadyExistingTable

Note:

here, Newtab = name of new table you want to create 

and, AlreadyExistingTable= name of table of which you want to make duplicate copy.


Enjoyyyyy..... :)

0 comments:

Post a Comment


                                                            

 
Design by Abhinav Ranjan Sinha