Removing Databases

Removing a database or a database object deletes both the structure and any data associated with it. For that reason, most systems allow you to issue a DROP command only if you own the object or have special permission to delete it.

The syntax of the DROP DATABASE command is usually something like this:

DROP DATABASE database_name

The DROP DATABASE command is very dangerous because removing a database obliterates all of its contents.