Query and Description

SELECT *
INTO EMP_COPY
FROM emp
WHERE 1=1;

This query will create the same table with data.

SELECT *
INTO EMP_COPY_2
FROM emp
WHERE 1=2;

This query will create the same table without data.

Comments

Join the conversation! Your thoughts help the community grow.