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


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

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

Enjoyyyyy..... :)


Post a Comment


Design by Abhinav Ranjan Sinha