--- Check if the field exists IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE Column_Name = 'NameOfTheField' AND Table_Name = 'YourTable') SELECT CAST(1 AS bit) AS Exists ELSE SELECT CAST(0 AS bit) AS Exists
--- Check if SP exists IF EXISTS(SELECT * FROM sysobjects WHERE Name = 'YourSPName' AND xType = 'P' SELECT CAST(1 AS bit) AS Exists ELSE SELECT CAST(0 AS bit) AS Exists