--Create Table Create table Test(Id int) Insert Test select 1 --Create Trigger Create Trigger Tri_Test On Test INSTEAD OF Delete As RollBack Tran--Test delete test where id=1
不好意思是sql server 2000的其实我的目的就是让某个表只能添加和修改不能删除!但在程序里写不保险我想直接利用sql server 2000里的约束功能直接设置,但不知道如何设置请各位帮帮忙,谢谢!
MSSQL 2005 禁止使用Drop Table命令CREATE TRIGGER Tri_Test ON DATABASE FOR DROP_TABLE //MSSQL 2005新增的DDL触发器 AS PRINT '不能删除表!' ROLLBACK
--Create Table
Create table Test(Id int)
Insert Test select 1
--Create Trigger
Create Trigger Tri_Test
On Test
INSTEAD OF Delete
As
RollBack Tran--Test
delete test where id=1
ON DATABASE
FOR DROP_TABLE //MSSQL 2005新增的DDL触发器
AS
PRINT '不能删除表!'
ROLLBACK