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 TRUNCATE and DELETE command
in SQL

Answer Posted / sathya

I just wanna add a point ..

while truncating a table both the structure and the datas will be removed. where as in Delete structure of the table ramains only the data in the table will be deleted.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between transaction type and transaction sources. : oracle accounts receivable

1067


What is supporting issues GL AP and AR?

2614


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3995


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2565


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2554


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1206


How would you determine who has added a row to a table?

2382


What is Tax Categories?

2159


HOW TO SPOT AHIERARCHY?

2342


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2462


what is semphore explian it?

2879


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2147


How do you create a credit note against an invoice? : oracle accounts receivable

1139


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2257


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

17779