Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 4930 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 the function of .h in #include<stdio.h> in c ?
23 Answers HCL, IBM, Wipro,
What is pass by value in c?
Are pointers integers in c?
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?
how to use showbits function?
What are the types of arrays in c?
#include<std.h> int main() { char *str[]={"Frogs","Do","Not","Die","They","Croak!"}; printf("%d %d\n",sizeof(str),strlen(str)); ...return 0; } what will the output of the above program?
where are auto variables stored? What are the characteristics of an auto variable?
YBJBU6
Why do we use stdio h and conio h?
a simple program in c language
Do you know what are bitwise shift operators in c programming?
C 
