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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the database roles? : sql server security

1161


Does a sql server 2005 select statement require a from?

1011


What is onf in normalization form?

1046


How real and float literal values are rounded?

1145


Can multiple columns be used in sql group by clause in ms sql server?

1039


how to trace the traffic hitting a sql server? : Sql server database administration

1859


What are the benefits and tasks of object explorer? : sql server management studio

1169


What is the process of normalising?

991


Define self join in sql server joins?

944


What are the different type of replication in sql server?

974


How to handle error or exception in sql?

974


Mention the 3 ways to get a count of the number of records in a table.

973


What is a select query statement in ms sql server?

1059


Why do we backup Active Directory ?

1036


Explain the rules for designing files and file groups in sql server?

977