GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Database  >  SQL Server

 Print  |  
Question:  How will you copy the structure of a table without copying the data?



January 01, 2008 15:27:13 #10
 chihoo2003   Member Since: January 2008    Total Comments: 4 

RE: How will you copy the structure of a table without copying the data?
 
select * into NEW_TABLE from SOURCE_TABLE where 1=2
     

 

Back To Question