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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

difference between truncate, delete aur drop?

Question Posted / ajayjuyal87

Answers were Sorted based on User's Feedback



difference between truncate, delete aur drop?..

Answer / 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

difference between truncate, delete aur drop?..

Answer / aman sharma

truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Explain what is raid and what are different types of raid levels?

0 Answers  

What is a raid and what are different types of raid configurations?

0 Answers  

How you can find out if an index is useful to the optimizer?

0 Answers  

What is the difference between DTS and SSIS?

3 Answers   Allianz,

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

How do I schedule a sql server profiler trace?

0 Answers  

Explain what are db_options used for?

1 Answers   InterGraph,

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

What are SSL and TSL protocols?

0 Answers   Wipro,

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

How to list all columns in a table using odbc_columns()?

0 Answers  

What are cursors and when they are useful?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories