There is one method for copying the structure of table without copying the data is create table NEWTABLE as select * from OLDTABLE where 1=2