How to: Check if a Microsoft SQL-server database exists?
Here’s an easy, single line statement to check if a database exists in the current SQL-server instance:
IF db_id('db_name') IS NOT NULL
programming.torensma.net: Code Snippets
Author
I am a .NET programmer first and foremost. But in my spare time I like to play around with PHP, Erlang, Haskell, F#, programmable calculators and what not. I even sometimes find the time to work on my Suzuki LJ80 , although this is very rare these days.