if not exists (database...) create database myDB

#1

Hi!

As the subjects says i wish to find out if a spesific database exist in my
sql server.

I wish to write following statement.

if not exists (select * from information_schema.databasename where
database_name = 'myDB')
Create Database myDB
GO

But I know i'm missing something.... Please help

---------------
Best regards
- Hans -
---------------
(Have fun programming with ... C#)

#2

You can query against the sysdatabases table in the Master database to see if
a specified database exists on the server.

This is how we build our databases if they don't already exist.

#3

Wha about

IF (SELECT DB_ID('Name')) IS NULL

....

Allan

"Hans [DiaGraphIT]" <hans.arsjo (AT) sshf (DOT) no> wrote

Quote:

Hi!

As the subjects says i wish to find out if a spesific database exist in
my
sql server.

I wish to write following statement.

if not exists (select * from information_schema.databasename where
database_name = 'myDB')
Create Database myDB
GO

But I know i'm missing something.... Please help

---------------
Best regards
- Hans -
---------------
(Have fun programming with ... C#)

#4

Hi Mike!

I really appreciate your quick respons. This was realy helpfull. Thank you
very much. :-)

---------------
Best regards
- Hans -
---------------
(Have fun programming with ... C#)

"Mike Sharpe" wrote:

Quote:

You can query against the sysdatabases table in the Master database to see if
a specified database exists on the server.

This is how we build our databases if they don't already exist.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

if not exists (database...) create database myDB

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

if not exists (database...) create database myDB - 11-15-2005 , 11:39 AM

RE: if not exists (database...) create database myDB - 11-15-2005 , 02:01 PM

Re: if not exists (database...) create database myDB - 11-15-2005 , 02:13 PM

RE: if not exists (database...) create database myDB - 11-15-2005 , 11:01 PM