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 is the difference Delete and Drop ?

Answer Posted / kasirajan

delete command deletes the table temporarily from the database. we can get it back using the keyword ROLLBACK.
but the drop keyword deletes the table permanently from the database,we cant able to get it back...

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you tell which of the following where clauses is faster?

991


How can we get total number of records by query in mysql?

958


What is the difference between BLOB AND TEXT?

1218


How do I edit a database in mysql workbench?

948


What is regexp?

1187


What are the method you will follow while sql installing

2398


What are the 'mysql' command line options?

1043


What language does mysql use?

950


Which storage engine is best in mysql?

1002


Restore database (or database table) from backup.

1068


What is the difference between mysql and oracle?

1007


What is the difference between heap table and temporary table?

1155


How big is a blob mysql?

934


What is the usage of regular expressions in mysql?

942


What is pdo mysql?

979