| public static GetDropDatabaseScript ( string databaseName ) : string | ||
| databaseName | string | |
| return | string | |
public static string GetDropDatabaseScript (string databaseName)
{
return string.Format (@"USE master
IF EXISTS (SELECT * FROM sysdatabases WHERE name = '{0}')
BEGIN
ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DROP DATABASE [{0}]
END", databaseName);
}