IF DATABASE EXISTS ???

• texpic

  SSCertifiable

  Points: 5887

  More actions

  February 5, 2007 at 9:17 pm

  #98050

  How can I do this?

  IF DATABASE MyDataBase EXISTS

  SELECT * FROM MyDataBase..MyTable

  END

   

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  February 5, 2007 at 10:08 pm

  #687909

  Hi

  If Exists (SELECT name from sysdatabases where name = 'MyDataBase')

  BEGIN

  USE MyDataBase

  select * from MyDataBase..MyTable

  END

  "Keep Trying"

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 6, 2007 at 1:56 am

  #687935

  That's still going to give an error, from the parsing of the USE statement 

  Could not locate entry in sysdatabases for database 'MyDB'. No entry found with that name. Make sure that the name is entered correctly.

  If you remove the use statement however, it works

  If

  Exists (SELECT name from sysdatabases where name = 'MyDB')

  begin

  select * from MyDB..sysobjects

  end

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass