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

main(){char *str;scanf("%s",str);printf("%s",str); }The error in the above program is: a) Variable 'str' is not initialised b) Format control for a string is not %s c) Parameter to scanf is passed by value. It should be an address d) none

726


What is return type in c?

639


What are the __date__ and __time__ preprocessor commands?

570


Given a valid 24 hour format time find the combination of the value and write a program ,do not hard the value and if any other inputs provided should work with the logic implemented Input: 11:30 Output: 13:10 Input: 18:25 Output: 21:58

1117


What are the advantages of c preprocessor?

713






Is the exit() function same as the return statement? Explain.

659


What are near, far and huge pointers?

645


Write a program for Overriding.

685


we called a function and passed something do it we have always passed the "values" of variables to the called function. such functions calles are called a) calls by reference b) calls by value c) calls by zero d) none of the above

633


What is the use of #include in c?

574


what is the height of tree if leaf node is at level 3. please explain

1602


What functions are in conio h?

658


What is the difference between far and near in c?

599


What language is lisp written in?

618


What is structure in c explain with example?

635