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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / jaydev

Answer Posted / jaydev

SELECT TOP 0* INTO tabname2 FROM tabname1

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are page splits?

995

Does sql server use java?

1076

Can you pass expressions to stored procedure parameters?

1037

tell me the disaster recovery plan

2516

Tell me about the approaches which you used to counter the DI problems.

1353

What is the difference between a view and a stored procedure?

1037

How to delete existing rows in a table?

1161

Can sql servers linked to other servers like oracle?

953

Explain various data region available in ssrs with their use?

934

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

971

Define outer join in sql server joins?

936

How to test values returned by a subquery with the in operator?

1197

Which Model uses the SET concept

984

What do you mean by an execution plan? Why is it used? How would you view it?

932

How do you rebuild an identity column?

949