What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 4314 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 |
main() { enum _tag{ left=10, right, front=100, back}; printf("%d, %d, %d, %d", left, right, front, back); }
program to find the magic square
What is #ifdef ? What is its application?
How can you find out how much memory is available?
Which type of language is c?
main() { char x; while(x=0;x<=255;x++) printf("\nAscii value %d Charater %c",x,x); }
Explain how can you restore a redirected standard stream?
what is the use of c program?
4 Answers Synergy, Web Synergies,
Can we access the array using a pointer in c language?
why in C,C++'s int size is 2 byte and .net(c#) int Size is 4 byte?
what is the little endian and big endian?
struct abc { unsigned int a; char b; float r; }; struct xyz { int u; struct abc tt; }ww; ww = (struct xyz*)malloc(sizeof(struct xyz)); will the memory be allocated for the inner structure also?
C 
