How will you copy the structure of a table without copying the data?
250417-Sep-2011
Updated on 20-Sep-2020
interview
Home / DeveloperSection / Interviews / How will you copy the structure of a table without copying the data?
hi I am software developer at mindstick software pvt. ltd.
Shekhar Kumar
06-Aug-2014SELECT*INTO NewTable FROM OldTable Where 1=2
Chris Anderson
17-Sep-2011There is one method for copying the structure of table without copying the data is
create table NEWTABLE as select * from OLDTABLE where 1=2