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?



September 09, 2005 03:32:22 #4
 rahultripathi   Member Since: September 2005    Total Comments: 22 
RE: How will you copy the structure of a table without...
 
Shobha Wrote:

but Rahul it's not run at SQL Query Analyzer, plze send the query for SQL,

Thanks

Dear Shobha

If your using SQL SERVER please Use this Syntex :-

select * Into NEWTABLE from OLDTABLE where 1=2

PLZ REPLY / query rahultripathi@myway.com

     

 

Back To Question