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?



July 07, 2006 00:45:21 #6
 Sridhar   Member Since: Visitor    Total Comments: N/A 

RE: How will you copy the structure of a table without...
 
This interview questions are belongs to SQL Server and people are giving answers to Oracle. Please be sure to understand the question and give the answer. Wrong answer may spoil a person interview. Here is the right answer
Without Data : select * into temp2 from temp where 1=2
With Data : select * into temp2 from temp
Regards
Sridhar
     

 

Back To Question