SqlServer Tigger

use Tig 2 GO 3 create trigger [Trigger名称] on [表名] 4 [触发条件](for Insert/for Update/after Insert/aftert Update) 5 as 6 print ‘输出‘

示例

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