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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete duplicate records based on single column from a table?

1003


What is cursors? And what are the different types of cursor?

1100


Does sql server 2000 clustering support load balancing?

913


Does sql server use java?

1008


What is cube dimension? : sql server analysis services, ssas

962


What are different types of statement?

954


What are the 7 disadvantages to a manual system?

921


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

848


How will you find out if there are expensive SQL statements running or not?

976


Why olap is used?

926


What are the five major components of a dbms?

892


How can you hide the sql server instances?

979


What is 2nf normalization?

978


How to change a login name in ms sql server?

1036


can a database be shrunk with users active? : Sql server administration

959