Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 5060 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
How do c compilers work?
What is the best way to store flag values in a program?
What are the types of unary operators?
Which node is more powerful and can handle local information processing or graphics processing?
what is the difference between north western polytechnique university and your applied colleges?? please give ur answers for this. :)
What is a newline escape sequence?
What is the meaning of && in c?
Mention four important string handling functions in c languages .
What are structural members?
What are the different types of errors?
Is c language still used?
What is scope of variable in c?
What is file in c preprocessor?
Explain what is a const pointer?
In c programming, explain how do you insert quote characters (? And ?) Into the output screen?
