Create a new table from another Table without data and new primary key
I want to create a new table "incident_tag", from an already existing table "incident" without the data of the "incident" table and a new Primary key , "sys_id)
Below is the query that I'm writhing, but I'm getting an error..
CREATE TABLE incident_tag
AS (SELECT * FROM "incident" WHERE 1=2 CONSTRAINTS incident_tag_pk PRIMARY KEY (sys_id) );
Execution error: ERROR: Syntax error at or near "CONSTRAINTS"