by pietman
18. July 2010 16:40
for procedures
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'') AND type in (N'P', N'PC'))
drop PROCEDURE
go
for views
IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[matching].[workingset_patient_episodes]') AND type in (N'V'))
drop view [matching].[workingset_patient_episodes]
go
8ff205f7-c162-4544-9060-aa0a92dfa013|0|.0
Tags: