duplicate a table

[pk]

hi

can you please tell me how to duplicate a table?
I tried this, but it didn't work

create table refer2 select * from refer;

any ideas?