Select INTO

Selects or copy the data from one table to another.


Select * INTO EMP_DB2 From EMP_DATABASE; 

Copies the data from EMP_DATABASE to EMP_DB2