create trigger tr_delete on 表
for delete
as
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+' if exists(select 1 from sysobjects where name='''
+字段+''' and xtype=''V'') drop view ['+字段+'] '
from deleted
create trigger tr_delete on 表
for delete
as
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+' if exists(select 1 from sysobjects where name='''
+字段+''' and xtype=''V'') drop view ['+字段+']'
from deleted
--改一下
create trigger trg_delete_tblname on tblname
for delete
as
begin
declare @sql varchar(8000)
set @sql=''
select @sql='if exists(select 1 from sysobjects where name='''+colname+''' and xtyle=''v'') drop view '+colname+' ' from deleted
exec(@sql)
end