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...

difference between truncate, delete aur drop?

Answer Posted / v.krishnakumar

in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are triggers? How do you invoke a trigger on demand?

1318


What method is used by the Command classes to execute SQL statements that return single values?

1067


What is a Join and explain its types?

1103


What is resource governor in sql server?

995


Do you know what is openxml in sql server?

1068


What is mapping schema?

1027


How is sql server used?

957


What is mean by candidate key?

1011


What do you think of this implementation? Can this be implemented better?

943


What is function of ROLLUP ?

1083


What is meant by datasource?

924


Which is faster statement or preparedstatement?

945


In what three ways is the return statement used in a stored procedure?

1008


Explain full-text indexing?

980


What is server-level principal?

122