Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?
- 2 Answers
- 4928 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 |
Why do we use c for the speed of light?
Write a C program to perform some of the operation which can be performed using Single linked list
When should you use a type cast?
can please someone teach me how to create this program using while statement.. this is the output should look like 0 2 4 6 8 10 -thanks.. :) need it asap...
What is difference between structure and union in c?
Write a function stroverlap that takes (at least) two strings, and concatenates them, but does not duplicate any overlap. You only need to worry about overlaps between the end of the first string and the beginning of the second string. Examples: batman, manonthemoon = batmanonthemoon batmmamaman, mamamanonthemoon = batmmamamanonthemoon bat, man = batman batman, batman = batman batman, menonthemoon = batmanmenonthemoon
How can I delete a file?
What are different types of variables in c?
How can draw a box in cprogram without using graphics.h header file & using only one printf(); ?
How do you use a pointer to a function?
code for replace tabs with equivalent number of blanks
What is the use of c language in real life?
C 
