.

sql stuff

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

One Response to this post.

  1. Posted by piet on 18.07.10 at 4:40 pm

    hello

What's your thoughts on this?

*

Protected by WP Anti Spam