Tuesday, August 26, 2014

copy table from one database to another database

Clone the table structure on target database


From source database



Insert into <targetdbname>.<tarSchemaName>.<tableName>
select * from <srcSchemaName>.<tableName>



--Prashanth



No comments:

Post a Comment