Do a “create table” as command without selecting any rows create table abc_new as select * from abc where 1=0;