What is the impact of dropping a database?

What happens when you drop database?

Dropping a database deletes the database from an instance of SQL Server and deletes the physical disk files used by the database. If the database or any one of its files is offline when it is dropped, the disk files are not deleted. These files can be deleted manually by using Windows Explorer.

Is dropping a database the same as deleting?

Simply: a DELETE command removes matching rows, a DROP command removes the entire table.

Why drop database if exists?

IF EXISTS is used to prevent an error from occurring if the database does not exist. If the default database is dropped, the default database is unset (the DATABASE() function returns NULL ). If you use DROP DATABASE on a symbolically linked database, both the link and the original database are deleted.

Does dropping database delete tables?

DROP will delete all data and the table structure as well. DELETE will delete the data but the table structure will remain the same and we can still rollback the data. Also with DELETE you can use the where condition i.e. to delete only certain records.