Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to check database exists or not in sqlserver

Anonymous User 1894 17 Jan 2016

I want to check database exists or not in sqlserver please help me.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 17 Jan 2016

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

MindStick Training