sys.sp_dbremove
general #stored-procedure
Description
Removes a database and all files associated with that database.
Syntax
sp_dbremove
[ [ @dbname = ]
N
'dbname'
]
[ , [ @dropdev = ]
'dropdev'
]
[ ; ]Examples
Example 1
sales
Example 2
EXECUTE sp_dbremove sales;