What's the difference between DELETE TABLE and TRUNCATE TABLE
commands?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

write a program to concatenation the string using switch case?

1560


How can I make it pause before closing the program output window?

581


Explain Basic concepts of C language?

646


How can I insert or delete a line (or record) in the middle of a file?

575


What is the difference between a string copy (strcpy) and a memory copy (memcpy)? When should each be used?

625






What is f'n in math?

621


the 'sizeof' operator reported a larger size than the calculated size for a structure type. What could be the reason?

566


What is meant by gets in c?

609


all c language question

1876


What should malloc(0) do? Return a null pointer or a pointer to 0 bytes?

591


What is the difference between malloc() and calloc()?

618


What’s a signal? Explain what do I use signals for?

611


How can I invoke another program or command and trap its output?

619


largest Of three Number using without if condition?

1009


What is #define used for in c?

615