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

How can I create a table from another table without copying any values from the old table?

Answer Posted / arun

Select top 0
into newtable
from oldtable

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you add a dimension to cube? : sql server analysis services, ssas

1012


Tell me what is sql profiler?

982


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

981


What is trace flag in sql server?

977


What are partitioned views and distributed partitioned views?

979


Can we hide the definition of a stored procedure from a use?

1135


How to create an inline table-valued function?

909


What is instead of dml trigger?

953


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

941


What is an indexed view?

919


What is enhanced database mirroring in sql server 2008?

915


How is table type constraint applied to a table?

936


What is a view and what are its advantages?

1054


What do you mean by recursive stored procedure?

884


Explain what is the main purpose of having conversation group?

882