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;