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 / hokar

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

Is This Answer Correct ?    18 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the index requirement in SQL Azure?

98


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2221


Does a server store data?

928


What are the rendering extensions of ssrs?

157


What is the maximum length of an alert name?

1001


How to create a dml trigger using create trigger statements?

1038


Where cross join is used?

968


What are the acid properties?

1007


Can foreign key be deleted?

929


What is a non clustered primary key?

927


What are .mdf files?

943


what is a join? : Sql server database administration

1254


Why use sub query in sql server and list out types of sub queries?

1000


Write SQL queries on Self Join and Inner Join.

1159


How many types of attribute relationships are there? : sql server analysis services, ssas

1079