Question: what is the difference between dropping a database and taking a database offline?
Answer: The difference is that detach deletes database metadata from SQL Server i.e. database file information, status information and all the other details that we see in sys. databases view. On the other hand taking database offline retains database metadata in SQL server system views.