SQL statement to create a new table from an old table in SQL

Today, on the Internet, according to the old table to create a new table SQL statement, the Web gave two answers

CREATE table tab_new like Tab_old (creating a new table with the old table )

CREATE TABLE tab_new as Select Col1,col2 ... From tab_old definition only

Two statements have been tried, error.

The correct method is select * into newtable from oldtable; If you do not want to lead the record, just want to make table structure: SELECT * into NewTable from oldtable where 1=2;

If newtable already exists, you want to import the record: INSERT INTO newtable select * from Oldtable where ...

Some of them also draw on some other friends, I summarize in this!!

SQL statement to create a new table from an old table in SQL