How can I find out, if database (@DataBaseName) exists? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How can I find out, if database (@DataBaseName) exists?

Message

De

05/03/2003 18:17:16

Bob Archer
Tampa, Floride, États-Unis

À

05/03/2003 14:30:30

Naomi Nosonovsky
Wisconsin, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: How can I find out, if database (@DataBaseName) exists?

Divers

Thread ID:

00761718

Message ID:

00761861

Vues:

19

This message has been marked as the solution to the initial question of the thread.

>Hi everybody,
>
>Is there a way to check, if the database exists? I know, how to do it for tables, but what about databases?
>
>Thanks.

You can use...

if db_id(@DataBaseName) IS NOT NULL
     PRINT @DataBaseName + ' exists!'

Click here to load this message in the networking platform