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 is the difference between Drop and Truncate

Answer Posted / madhu

drop will delete the entier table content including its
structure.
but truncate will delete the datas which in the table.

it wont save the data any where so we cannot rollback those
data.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Business Edition in SQL Azure?

100


Do you know how to store and query spatial data?

1040


Relational calculus is what type of language?

1037


What is the difference between clustered index and primary key?

922


What is partitioned view?

900


you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

946


How to set database to be read_only in ms sql server?

1011


Can a unique index be created on a column, which contains null?

919


Mention the different types of triggers?

1118


How to change the ownership of a schema in ms sql server?

1194


how can you check the level of fragmentation on a table? : Sql server administration

984


Explain about merge replications?

1027


Explain “not null constraint” in sql server?

1033


What are the purpose of Normalisation?

1050


What is a partition function in sql server?

1137