SQL – Duplicate Table

CREATE TABLE [newtable] LIKE [oldtable]

OR

CREATE TABLE TEST
AS (SELECT VAR1, VAR2, VAR3
FROM TABLE) WITH DATA
UNIQUE PRIMARY INDEX(VAR1);

Leave a Reply

Your email address will not be published. Required fields are marked *