Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I find out, if database (@DataBaseName) exists?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00761718
Message ID:
00761722
Views:
26
>>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.
>
IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
>			WHERE catalog_name = 'master'	)
>	PRINT 'Yes'
>
Interesting. In the time you answered I found the info in the Master database SysDatabases table. Is your way better?

And where do you reference my database name?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform