Create a backup of employee table with emp_tbd name in SQL

Question

How to create a backup of employee table with emp_tbd name ?

Satyapriya Nayak · Answer

select * into newtable from oldtable SELECT * INTO emp_tbd FROM employee