Drop A Database When The Name Is Supplied As A Varible

I have created a stored procedure that will back up a database to a file then restore the database into a new db. The stored procedure accepts 2 parameters that determine the name of the old DB to be backed up and the name of the new DB to be created. The only problem now is that when you specify the name of a database that already eixists, the restore fails. I want to add an if statement that would check to see if the new db supplied exists, and if it does drop it before running the restore.

I thought the following would work but it does not




Code Block
declare @DB nvarchar (50)
set @DB = 'LDRPSsmap2k'

IF EXISTS (SELECT name FROM sys.databases WHERE name = @db)
Drop Database @db


I get When i run this

Msg 102, Level 15, State 1, Line 7

Incorrect syntax near '@db'.