摘要:
存储过程if(exists(select * from sysobjects where name='存储过程的名字' and Type='P'))触发器: select * from sysobjects where id=object_id(N'触发器的名字') and objectproperty(id,N'IsTrigger')=1如果判断用户表格的话,用IsUserTable 代替 上面的IsTrigger函数select * from sysobjects where id = object_id(N'[dbo 阅读全文