sql table backup same db with new name query

SELECT *
INTO <new table name>
FROM <Source table name>;