Hi Reader's,
Welcome to FindNerd, today we are going to discuss what is process to Copy entire date into other table in SQL Database ?

If you want to copy a SQL table into another table in the same SQL database then you should use copy statement.

Syntax of SQL Copy Table

select * into destinationTable from sourceTable ;

you can see below example:

suppose you have a table name is employee

 **Employee name**  **Employee Age** **Employee Id**
          Deepak                         30                            1
          Nishant                         25                            2   

 Now you want copy to same record another table in same database   

INSERT INTO employeeinfo SELECT * FROM employee;

So student table data will copied into employeeinfo.