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

what is constraints? Also explain the different types of constraints?

974


What is the difference between char and varchar in mysql?

1119


Can a table have multiple primary keys?

903


Where does mysql store data?

879


What, if a table has one column defined as TIMESTAMP?

1013


what is mysql optimization in brief?

2362


Can mongodb replace mysql?

942


What is difference between mysql and mariadb?

1112


Will mysql remain free?

961


What are the features of mysql?

989


How do you name a table?

895


How to convert character strings to dates?

1087


What is difference between inner vs self vs cross?

964


What is mysql database extension?

1029


How to use 'mysql' to run sql statements?

1095