How to Copy Table Structure?

Topic Introduction: In this tutorial, we will see How to Copy Table Structure With Data & Without Data?

Copy Without Data

CREATE TABLE COPY_EMPLOYEES

AS

    (SELECT *

       FROM EMPLOYEES

      WHERE 1 = 2);

Copy With Data

CREATE TABLE COPY_EMPLOYEES

AS

    (SELECT *

       FROM EMPLOYEES);