HOW WILL YOU COPY THE STRUCTURE OF A TABLE WITHOUT COPYING THE DATA?

Chris Anderson

Total Post:197

Points:985
Posted by  Chris Anderson
 1579  View(s)
Ratings:
Rate this:
  1. Chris Anderson

    Post:197

    Points:985
    How will you copy the structure of a table without copying the data?

    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


  1. Shekhar Kumar

    Post:1

    Points:5
    How will you copy the structure of a table without copying the data?

    There is one method for copying the structure of table without copying the data is
    SELECT * INTO NewTable FROM OldTable Where 1=2

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!