Delete is DML Command ,Whereas Trucate is DDL command Delete can be Roll

what is the difference between TRUNCATE and DELETE command
in SQL

Question Posted / dheeraj

23 Answers
66510 Views
ICICI, Saama Tech, SkyTech, TCS, I also Faced
E-Mail Answers

Answer Posted / dheeraj

Delete is DML Command ,Whereas Trucate is DDL command

Delete can be Rolled Back,Truncate cannot be rolled back,

Truncate is much faster then Delete

Delete will not released the memory space ,Memories would
be same if we use delete command the structure of the
table is still there

Trncate can be free the space in the meomory

Delete , use check constraints if exits then show error

Truncate don't use check constraint

Is This Answer Correct ?

13 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to write customizations in po

1619

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1050

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2217

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

2327

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1129

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

17644

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2076

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1348

What is the difference between oracle media recovery and crash recovery?

1176

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1145

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2223

What is Restricted Mode of Instance Startup in Oracle?

1201

What is the difference between recovery and restoring of the oracle database?

1222

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2297

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1165