Search code examples
sql-serversqlcmddrop-database

SQLCMD - trying to drop a database with alphanumeric name '14Data' gives Syntax Error

I am using SQL SERVER 2005 Express. I can delete the database from the query analyzer, what you call Mgmt Studio (ssmsee) by providing double quotes to the database name and things get done;

Drop Database "14data" Go

and the db is gone,

but sqlcmd gives error on 14 (Msg 102 Level 15 State 1 Incorrect sysntax near 14 ) May be it considers numeric part as some other thing and not the database name, I tried with N'',"", $(), also tried variables and executing correct sql script files (that ran correctly on mgmt studio) but it gives the same error at the exact same place.

Has any1 ever deleted a database with alphanumeric db name from SQLCMD ?

Solution

  • You may be able to enclose it [] brackets.

    e.g.

    drop database [14data] go