Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what command is used to create a table by copying the
structure of another table?

Answers were Sorted based on User's Feedback



what command is used to create a table by copying the structure of another table?..

Answer / hokar

SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)

Is This Answer Correct ?    18 Yes 4 No

what command is used to create a table by copying the structure of another table?..

Answer / pradip jain

SELECT * INTO tblNew FROM tblOld WHERE 1=2

Is This Answer Correct ?    7 Yes 0 No

what command is used to create a table by copying the structure of another table?..

Answer / kumar.t

Select * into newnew1 from newnew WHere 1=2

Is This Answer Correct ?    4 Yes 0 No

what command is used to create a table by copying the structure of another table?..

Answer / jaydev

SELECT TOP 0* INTO tabname2 FROM tabname1

Is This Answer Correct ?    5 Yes 3 No

what command is used to create a table by copying the structure of another table?..

Answer / naik

select * into oldtable from newtable where oldtable
=newtable

Is This Answer Correct ?    2 Yes 1 No

what command is used to create a table by copying the structure of another table?..

Answer / kunal sain

create table table_name
as select * from another_table
where 1>2;

Is This Answer Correct ?    7 Yes 9 No

what command is used to create a table by copying the structure of another table?..

Answer / narsing

SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

syntax for deleting the database in T SQL

5 Answers  


What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  


Create and insert into temp table in sql server?

0 Answers  


How to sort query output in descending order in ms sql server?

0 Answers  


When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  


Can we write trigger for view?

0 Answers  


Can a database be shrunk to 0 bytes, if not, why?

0 Answers  


system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  


Differentiate between truncate vs delete in mssql?

0 Answers  


Can I save my report as html, excel or word? : sql server management studio

0 Answers  


What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,


What is log shipping?

0 Answers  


Categories