SqlServer Tigger

示例

1    use Tig
2    GO
3    create trigger TiggerName on A
4    after Insert
5    as
6    print ‘Insert A‘

查询所有的Trigger

1    select * from sysobjects where xtype=‘TR‘

查询指定Trigger

1     exec sp_helptext [Trigger名称]

删除指定Trigger

1     drop trigger [Trigger名称]

SqlServer Tigger

标签：post   date   for   type   color   数据库   数据   sys   obj