How will you copy the structure of a table without copying the data?
Ask by Chris Anderson
Updated 20 Sep 2020
SELECT * INTO NewTable FROM OldTable Where 1=2
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