Create Duplicate Table in SQL Server with Different Name

Hello Techies,


Today i am going to explain how to create duplicate table with data in sql server with same name.
Please follow bellow code for this. This is very simple to do that.

Select * into <Destination Table Name>  from <Existing Table >
Ex:  Select * into Dev.dbo.TableB from Dev.dbo.TableA



 Thanks
Create Duplicate Table in SQL Server with Different Name Create Duplicate Table in SQL Server with Different Name Reviewed by Ashwani on November 21, 2018 Rating: 5

No comments:

Powered by Blogger.