What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
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 |
EXPLAIN #INCLUDE<STDIO.H> EXPLAIN #INCLUDE<CONIO.H>
Describe newline escape sequence with a sample program?
Why the below program throughs error during compilation? #include<stdio.h> #include<conio.h> enum { ZERO, ONE, TWO, }; main() { printf("%d",&TWO); getch(); }
what is disadvantage of pointer in C
the number of measuring units from a arbitrary starting point in a record area or control block to some other point a) branching b) recording pointer c) none d) offset
write an algorithm to get a sentence and reverse it in the following format: input : I am here opuput: Here Am I note: first letter of every word is capiatlised
WHAT IS THE DEFINATION OF IN TECHNOLOGY AND OFF TECHNOLOGY ?
What is zero based addressing?
write a program in c to find out the sum of digits of a number.but here is a condition that compiler sums the value from left to right....not right to left..
Can I use base-2 constants (something like 0b101010)? Is there a printf format for binary?
write a program to convert a expression in polish notation (postfix) to inline (normal)
main() { int x=20,y=35; x = y++ + x++; y = ++y + ++x; printf("%d %d\n",x,y); }
27 Answers Advent Global Solutions, CitiGroup, Valeo Lighting Systems India Private Limited, Vishal Transformers, Wipro, Zencer,