Pass DB name as variable in if exists statement

Question

I have a query as below

IF EXISTS( SELECT * from @dbname.dbo.tbl1)
   BEGIN
   ...
   END
ELSE
   BEGIN
   ...
   END

Also The code in begin and end part for both if and else is large enough to use as a string for dynamic query. How can I achieve this?

Alfons, I am not sure about try except, can you please explain in brief. — azim
– azim, Commented Oct 22, 2013 at 9:01

Raj · Accepted Answer · 2013-10-22 09:09:20Z

1

USE MASTER
DECLARE @dbname sysname
SET @dbname = 'MyDB'

IF EXISTS (SELECT NULL FROM sysdatabases WHERE name = @dbname)
BEGIN
-- Action if true
END
ELSE
BEGIN
-- Action if False
END

In case you want to check for a specific table, as hinted in your question, you can modify as

IF EXISTS (SELECT NULL FROM sysobjects WHERE name = @dbname AND type = 'U')

answered Oct 22, 2013 at 9:09

Raj

10.9k2 gold badges47 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pass DB name as variable in if exists statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related