I know we can simply create a new table and copy the old table by doing
select * into tbl2 from tbl1
i would like to check if table tbl2 exists, if it does then copy all the rows, if it doesn't then create a new one without having to specify the column names in tbl2 since I'm copying all the columns from tbl2 in tbl1. then, I would like to drop old table(tbl1)
if not exists(select * from tbl1 where id = 1)
create table tbl2()
drop tbl1
go