Monday, April 3, 2017

Duplicate Table in Sql Server , Oracle and MySql


 SQL Server 




SELECT *
INTO NEW_TABLE_NAME
FROM OLD_TABLE;




Oracle & MySql 







CREATE TABLE NEW_TABLE_NAME AS (SELECT * FROM OLD_TABLE);


Get more from  : http://techprogramme.com/

0 comments:

Post a Comment