SQL Server 2000/2005检测存储过程名是否存在,存在删除

IF OBJECT_ID ( 'pr_DictDel', 'P' ) IS NOT NULL
    Drop PROCEDURE pr_DictDel;
GO