SQL simple -> Create empty copy of existing table

The following statment creates empty copy of Employees table:
SELECT * INTO NewEmp
FROM Employees
WHERE 0=1;

In the WHERE clause the condition is FALSE, so no records are copied.


sqlexamples.info