Oracle CREATE TABLE TABLE_NAME_BAK AS SELECT * FROM TABLE_NAME sqlserver Select * into tablename_bak from tablename