sql server 2000/2005/2008 判断存储过程、触发器、视图是否存在并删除
<br />--判断是否存在addOneArticle这个存储过程<br />if Exists(select name from sysobjects where NAME = 'addOneArticle' and type='P') <br /> drop procedure addOneArticle<br /><br />--判断是否存在countAr这个触发器<br />if exists(select * from dbo.sysobjects where id = object_id(
转载
2011-02-22 16:16:00 ·
821 阅读 ·
0 评论