IF EXISTS (SELECT *
FROM master..sysdatabases
WHERE name = N'<database_name, sysname, test_db>')
DROP DATABASE <database_name, sysname, test_db>
GO
FROM master..sysdatabases
WHERE name = N'<database_name, sysname, test_db>')
DROP DATABASE <database_name, sysname, test_db>
GO
print 'exists'
else
print 'not exists'
SELECT count(*) FROM [master].[dbo].[sysdatabases] where [name] =检查的数据库名返回值等于1,存在,0 不存在