What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 3715 Views
- CTC, I also Faced
- E-Mail Answers
Answer Posted / naveen reddy
delete table deletes entire table if we want to delete or else we can delete specific column or row.
if we wish to simply get rid of the data but not the table itself? For this, we can use the TRUNCATE TABLE command. The syntax for TRUNCATE TABLE is
TRUNCATE TABLE "table_name"
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is %d used for?
Is exit(status) truly equivalent to returning the same status from main?
What is the maximum length of an identifier?
How can you increase the size of a dynamically allocated array?
praagnovation
How can I swap two values without using a temporary?
Describe the header file and its usage in c programming?
swap 2 numbers without using third variable?
What is define directive?
Why are some ANSI/ISO Standard library routines showing up as undefined, even though I've got an ANSI compiler?
Explain the properties of union.
What is the difference between text files and binary files?
How to compare array with pointer in c?
application attempts to perform an operation?
What is the use of header?
