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 DELETE and TRUNCATE?

Answer Posted / althaf

the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informix sql?

986


what is schema? : Sql dba

1054


What is the use of sqlerrd 3?

947


What is lexical units in pl sql?

1155


What is sql clause?

1057


What does joining a thread mean?

1024


Why do we need sharding?

1002


What are the commands used in sql?

1087


what are the authentication modes in sql server? How can it be changed? : Sql dba

1442


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1011


How to raise user-defined exception with custom sqlerrm ?

1139


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1006


can sql servers linked to other servers like oracle? : Sql dba

1013


What is the purpose of primary key?

1034


What is left join example?

957