If you want to duplicate a table in SQL with the same Fields and records you can use the following statement
SELECT * INTO New_Table FROM Exsisting_Table
This will create New_Table and copy all data from the Exsisting_Table.
We can use the WHERE clause to filter what data we need in the New_Table.