use Per_Rain
go
--创建触发器,禁止删除表
CREATE TRIGGER [TS_no_deleted]
ON DATABASE
after DROP_TABLE
AS
begin
raiserror('不允许删除表',11,1)
return
end
go
--创建触发器,禁止删除表
CREATE TRIGGER [TS_no_deleted]
ON DATABASE
after DROP_TABLE
AS
begin
raiserror('不允许删除表',11,1)
return
end
--生成 一个新表
select top 0 *
into aa
from dbo.zengsino重复
--删除试试
drop table aa
select top 0 *
into aa
from dbo.zengsino重复
--删除试试
drop table aa
--删除触发器
drop TRIGGER [TS_no_deleted] ON DATABASE
drop TRIGGER [TS_no_deleted] ON DATABASE