How to check if a database exists in SQL Server?

by

Actually, it’s best to use:

IF DB_ID('dms') IS NOT NULL
   --code mine :)
   print 'db exists'

See https://docs.microsoft.com/en-us/sql/t-sql/functions/db-id-transact-sql and note that this does not make sense with the Azure SQL Database.

More Related Contents:

  1. Create a view with ORDER BY clause
  2. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  3. TSQL: Create a view that accesses multiple databases
  4. How do I create a unique constraint that also allows nulls?
  5. How do I get list of all tables in a database using TSQL?
  6. Get first day of week in SQL Server
  7. What is the significance of 1/1/1753 in SQL Server?
  8. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  9. Escape a string in SQL Server so that it is safe to use in LIKE expression
  10. Insert Update trigger how to determine if insert or update
  11. SQL Server: Difference between PARTITION BY and GROUP BY
  12. How do you truncate all tables in a database using TSQL?
  13. Understanding SQL Server LOCKS on SELECT queries
  14. SQL Server: How to select all days in a date range even if no data exists for some days
  15. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  16. TSQL: How to convert local time to UTC? (SQL Server 2008)
  17. T-SQL Dynamic SQL and Temp Tables
  18. Need to list all triggers in SQL Server database with table name and table’s schema
  19. SQL Server Output Clause into a scalar variable
  20. How to create a yes/no boolean field in SQL server?
  21. Best way to store time (hh:mm) in a database
  22. How do I select last 5 rows in a table without sorting?
  23. SELECT INTO a table variable in T-SQL
  24. How can I insert binary file data into a binary SQL field using a simple insert statement?
  25. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  26. Date range overlapping check constraint
  27. Include missing months in Group By query
  28. Pivot multiple columns based on one column in SQL Server
  29. @@ERROR and/or TRY – CATCH
  30. Tool for Scripting Table Data

Leave a Comment