Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 5187 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 a spanning Tree?
What does %p mean c?
If fflush wont work, what can I use to flush input?
What are the main characteristics of c language describe the structure of ac program?
How can I discover how many arguments a function was actually called with?
What is the use of getchar() function?
how can f be used for both float and double arguments in printf? Are not they different types?
What are compound statements?
What does 4d mean in c?
What is difference between structure and union in c?
What are the 5 elements of structure?
What is line in c preprocessor?
why to assign a pointer to null sometimes??how can a pointer we declare get assigned with a garbage value by default???
What do you mean by Recursion Function?
What does a pointer variable always consist of?
