What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 4043 Views
- CTC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kalyan
truncate table means structure of table cannot deleted but
it deletes the data in the table. And Delete command deletes
the entire table with data.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is output of the following program ? main() { i = 1; printf("%d %d %d\n",i,i++,i++); }
Program to simulate second clock
write a program to swap two variables a=5 , b= 10 without using third variable
to find the closest pair
What is malloc and calloc?
By using C language input a date into it and if it is right?
Write a program to swap two numbers without using third variable in c?
Can you add pointers together? Why would you?
Can we declare function inside main?
Write a C program to find the smallest of three integers, without using any of the comparision operators.
Write a program to print fibonacci series without using recursion?
How can you tell whether a program was compiled using c versus c++?
C 
