首页 > 代码库 > SQL Server 触发器2

SQL Server 触发器2

DDL 触发器:

  create trigger trigger_name 

  on all server | database

  with encryption | execute as[...]

  for create_table | create_index |......

  as

  ---------

  ---------

例子:

  create trigger trigger_for_login

  on all server

  for create_login

  as

    print ‘你不可以创建用户‘;

    rollback;

  go

 

SQL Server 触发器2