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 / gourvendra singh

Truncate will remove the watermark from the table, but the
delete will not.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Cite the differences between execution of triggers and stored procedures?

1075


Why are indexes and views important to an organization?

950


How do you truncate?

902


What is an example of translating a date into julian format?

1115


What is the usage of when clause in trigger?

1051


What are predefined functions in sql?

1042


How do I order by ascending in sql?

1009


Do foreign keys improve performance?

1020


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1162


What is normalisation and its types?

998


Explain the update statement in sql

981


How do I view a sql trace file?

1024


How do you optimize a stored procedure in sql?

950


What is a behavioral trigger?

970


What is difference between hql and native sql?

1164