How to Copy a Table With or Without Data Using CREATE TABLE AS Statement

1. How to copy both the structure and data of a table

      create table emp_copy

      as

      select * from emp;

2. How to copy specific columns of a table along with their data.

     create table emp_copy

     as

     select empno, sal from emp;

3. How to copy only the structure of the table without the data.

    create table emp_copy

    as

    select * from emp

     where 1=0;

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.