CREATE TABLE ... LIKE not working

Question

Need help trying to create a table using CREATE TABLE ... LIKE, code is below, error given is

Incorrect syntax near the keyword 'LIKE'

CREATE TABLE jobserve_reports LIKE Jobserve

I've tried putting the LIKE in quotations with no luck, tried making it a temporary table, using curly braces and nothing has worked. Am at my wits end.

Answer 1

In SQL Server, we can create using:

SELECT * 
INTO newtable 
FROM oldtable 
WHERE 1 = 0;

Answer 2

If LIKE is not available in your db you could use create select

CREATE TABLE jobserve_reports AS 
select * from  Jobserve

or equivalent

eventuallly using

CREATE TABLE jobserve_reports AS 
select * from  Jobserve
where 1 = 2 

for get no result