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 Difference Between delete and Truncate?

Answer Posted / joe

Delete is DML and truncate is DDl;
both or used to delete the records from the table.

We can rollback the deleted records but we cant when we used truncate.

Delete is faster than truncate

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible for a table to have more than one foreign key?

972


How to convert comma separated string to array in pl/sql?

1104


What is procedure explain with example?

893


What are different categories of sql commands?

1067


Explain the purpose of %type and %rowtype data types?

873


How do I remove sql developer from windows 10?

1011


How can we solve sql error: ora-00904: invalid identifier?

1161


How do I enable sql encryption?

965


How sql query is executed?

1064


how to concatenate two character strings? : Sql dba

1029


What is the use of & in pl sql?

984


What is compilation error in pl sql?

920


what are the types of join and explain each? : Sql dba

989


Are subqueries faster than joins?

948


How many primary keys can a table have?

949