DROP DATABASE (TSQL Statement)
deletes the specified database.
Syntax
DROP DATABASE database_name
Arguments
- database_name
- is the name of the database to drop.
Remarks
Only sa is allowed to execute this statement.
All tables, users, roles, permissions are deleted. All files and directories storing the data of the database are deleted.
Examples
DROP DATABASE mydb;