Database Administration – Quick Copy of Table

Here is a quick way to create a copy of table:

SQL Server:
SELECT * INTO {NEWTABLENAME} FROM {ORIGINALTABLENAME};

Oracle:
CREATE TABLE {NEWTABLENAME} AS (SELECT * FROM {ORIGINALTABLENAME});