Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
verify if database existsHi, Is there a simple way to verify if a database exists? I'm writing a stored procedure that will accept a database name as an input parameter, and create the database if it does't already exist. -- Message posted via http://www.webservertalk.com
Post Follow-up to this message
Re: verify if database existsIF DB_ID('dbname') IS NULL
print 'missing'
else
print 'exists'
Tim S
Post Follow-up to this message Re: verify if database existsGot it. Thanks.
Tim wrote:
>IF DB_ID('dbname') IS NULL
> print 'missing'
>else
> print 'exists'
>
>Tim S
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200511/1
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
