Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 5083 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 the right way to use errno?
What is the newline escape sequence?
Write a factorial program using C.
What are qualifiers and modifiers c?
Who is the founder of c language?
Can we use visual studio for c?
How is a structure member accessed?
What is static memory allocation? Explain
Is malloc memset faster than calloc?
In the DOS enveronment, normal RAM that resides beyond the 1mb mark. a) expanded memory b) swapped memory c) Extended memory d) none
What is the purpose of sprintf() function?
Q.1 write a program to create binary tree 1 to 16 numbers? Q.2 write a program to creat a binary search tree for the member that is given by user?
What is void main () in c?
Explain how can you tell whether two strings are the same?
What are enums in c?
