Methods for Checking Object Existence in SQL Server
1. Check if a Database Exists IF EXISTS (SELECT 1 FROM sys.databases WHERE name = 'TargetDatabase') DROP DATABASE TargetDatabase; 2. Check if a Table Exists IF OBJECT_ID(N'dbo.TargetTable', N'U') IS NOT NULL DROP TABLE dbo.TargetTable; 3. Check if a Stored Procedure Exists IF OBJECT_ID(N'dbo.TargetP...