How to check database exists or not in sqlserver

Question

How to check  database exists or not in sqlserver

Anonymous User · Answer

if we want to check database exists or not we can know four way.

-- Solution number (1)
DECLARE @Database_Name varchar(100)
SET @Database_Name='forum'
IF EXISTS(SELECT * FROM sys.sysdatabases where name=@Database_Name)
PRINT 'The database already exists'
else
PRINT 'The database does not exist'

-- Solution number (2)
DECLARE @Database_Name varchar(100)
SET @Database_Name='forum'
IF EXISTS(SELECT * FROM master..sysdatabases WHERE name=@Database_Name)
PRINT 'The database already exists'
else
print 'The database does not exist'

-- Solution number (3)
DECLARE @Database_Name varchar(100)
SET @Database_Name='forum'
DECLARE @sql varchar(1000)
SET @sql='if ''?''='''+@Database_Name+''' print ''the database already alexists'''
EXEC sp_msforeachdb @sql 

-- Solution number (4)
DECLARE @Database_Name varchar(100)
SET @Database_Name='forum'
DECLARE @sql varchar(1000)
SET @sql='if exists(select * from ?.information_schema.schemata where
catalog_name='''+@Database_Name+''') print ''the database already exists'''
EXEC sp_msforeachdb @sql

forum

How to check database exists or not in sqlserver

Anonymous User

Can you answer this question?

1 Answers

Liked By