<< CSS References, Tutorials, Cheat Sheets, Conversion Tables and Short Codes | Ulysses: Sweny’s Pharmacy >>

T-SQL: Check if database exists

by Joe Hunter 15. March 2010 17:23

To check if a database exists, use the DB_ID() function:

IF db_id('AdventureWorks') IS NOT NULL
Print 'Database Exists'
ELSE
Print 'Database Does Not Exists'

Tags: t-sql

SQL Server

T-SQL function to return name of log file for a database ALTER FUNCTION [dbo].[UDF_DB_LOG_FILE_NAME] ( &...T-SQL to drop all non-system databases in SQL server instance EXEC sp_MSforeachdb 'IF DB_ID(''?'') > 4BEGINALTER DATABASE ? SET SINGLE_USER WITH ROLLBACK IM...Using T-SQL to get database nameIf you need to get the database name in T-SQL sproc: select db_name()

T-SQL: Check if database exists

Advertisement

Tag cloud

Page List