CREATE TABLE [newtable] LIKE [oldtable]
OR
CREATE TABLE TEST
AS (SELECT VAR1, VAR2, VAR3
FROM TABLE) WITH DATA
UNIQUE PRIMARY INDEX(VAR1);
OR
CREATE TABLE TEST
AS (SELECT VAR1, VAR2, VAR3
FROM TABLE) WITH DATA
UNIQUE PRIMARY INDEX(VAR1);