sql怎么用触发器撤销删除?

创建ddl触发器，在删除表时撤销删除表的操作

create trigger CheckDelete
on 表
for delete
as
begin
    rollback  //回滚
end