sql stuff

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

Tags:

Comments (1) -

piet
piet
8/16/2010 11:15:07 AM #

hello

Reply

Add c0mment




  Country flag
biuquote
  • Comment
  • Preview
Loading


About ...

pietman celliersPietman Celliers
Bitlink  Ltd
bitlinkit.com