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 is etl - extraction, transformation, and loading?

857


Explain cursor as data base object?

974


Tell me about the approaches which you used to counter the DI problems.

1268


How to make a remote connection in a database?

925


How dts is used to extract, transform and consolidate data?

1020


How to view the error log for any specific instance? : sql server database administration

985


Explain hostprotectionattribute in sql server 2005?

959


What is join query?

836


Explain tablesample?

945


How to create a simple table to test triggers in ms sql server?

913


Can we call stored procedure in trigger?

907


Do you know what is rank function?

1028


What are the essential components of sql server service broker?

964


What is sql injection and why is it a problem? : sql server security

1067


Does partitioning ssd reduce performance?

846