Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Answers were Sorted based on User's Feedback



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

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

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

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

Post New Answer

More C Interview Questions

a=0; b=(a=0)?2:3; a) What will be the value of b? why b) If in 1st stmt a=0 is replaced by -1, b=? c) If in second stmt a=0 is replaced by -1, b=?

6 Answers   Geometric Software,


Write a program to print a (*)pattern programming (A to Z) in capital in one programming ?

2 Answers   TCS,


Explain Doubly Linked Lists?

3 Answers  


stripos — Find position of first occurrence of a case- insensitive string int stripos ( char* haystack, char* needle, int offset ) Returns the numeric position of the first occurrence of needle in the haystack string. Note that the needle may be a string of one or more characters. If needle is not found, stripos() will return -1. The function should not make use of any C library function calls.

0 Answers  


how can i calculate mean,median,mode by using c program

1 Answers   HCL,


related to rdbms query .

2 Answers  


What is the difference between c and python?

0 Answers  


When reallocating memory if any other pointers point into the same piece of memory do you have to readjust these other pointers or do they get readjusted automatically?

0 Answers   TISL,


a=10;b= 5;c=3;d=3; if(a printf(%d %d %d %d a,b,c,d) else printf("%d %d %d %d a,b,c,d);

0 Answers   Wilco,


program to convert a integer to string in c language'

0 Answers  


Explain what is wrong with this program statement? Void = 10;

0 Answers  


What does the message "warning: macro replacement within a string literal" mean?

1 Answers  


Categories