Quick SQL question

[45_ACP]

Hi,

Is there any way to take an entire table’s contents and insert it into another table without inserting row by row? Can I create a copy of a table with SQL? The idea is to automatically create a backup.

Thanks!

-45