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 / shankar

DELETE and TRUNCATE both delete table from database, but

DELETE - temperorily deletes the table so we can undo the
table.

TRUNCATE - Perminently delete the table from database so we
cant undo it.

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is truncate ddl or dml?

991


What is on delete restrict?

1001


How are functions and procedures called in PL/SQL?

1231


What is join view in sql?

945


What is sql injection vulnerability?

945


Which is better join or subquery?

1137


What are the two types of cursors in pl sql?

1082


explain the difference between bool, tinyint and bit. : Sql dba

1002


What is offset and limit in sql?

1059


Is stored procedure faster than query?

969


What do you understand by case manipulation functions?

1034


How do I create a sql database?

1003


What are the indexing methods?

1049


What is the basic structure of an sql?

1099


What is user in sql?

1025