DB2
Use the LIKE clause with the CREATE TABLE command:
create table dept_2 like dept
Oracle, MySQL, and PostgreSQL
Use the CREATE TABLE command with a subquery that returns no rows:
1 create table dept_2 2 as 3 select * 4 from dept 5 where 1 = 0
SQL Server
Use the INTO clause with a subquery that returns no rows:
1 select * 2 into dept_2 3 from dept 4 where 1 = 0