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

we need to calculating INCOME TAX for the person. The INCOME TAX is as follows:- First $10000/- of income : 4% tax Next $10000/- of income : 8% tax Next $10000/- of income : 11.5% tax above $10, 00,00/- : 15% tax What is the Solution of this Question ?

1033


What is #include called?

808


Explain what will be the outcome of the following conditional statement if the value of variable s is 10?

1008


write a C program: To search a file any word which starts with ?a?. If the word following this ?a? starts with a vowel.Then replace this ?a? with ?a? with ?an?. redirect with the output onto an output file.The source file and destination file are specified by the user int the command line.

2656


How can I manipulate strings of multibyte characters?

823


What is bash c?

767


Why do we use main function?

909


Which of these functions is safer to use : fgets(), gets()? Why?

879


Write a code of a general series where the next element is the sum of last k terms.

809


How can I determine whether a machines byte order is big-endian or little-endian?

827


What are the general description for loop statement and available loop types in c?

904


please can any one suggest me best useful video tutorials on c i am science graduate.please help me.u can email me to sas29@in.com

1566


What are the different file extensions involved when programming in C?

1018


Explain how are 16- and 32-bit numbers stored?

1021


Write a C Program That Will Count The Number Of Even And Odd Integers In A Set using while loop

1924