ALTER EVENT [ owner.]event-name 
[ AT { CONSOLIDATED | REMOTE | ALL } ]
[ FOR { PRIMARY | ALL} ]
[ { DELETE TYPE 
   | TYPE event-type 
   | WHERE { trigger-condition | NULL }
   | { ADD | ALTER | DELETE } SCHEDULE schedule-spec } ]
[ ENABLE | DISABLE ]
[ [ ALTER ] HANDLER compound-statement | DELETE HANDLER ]

event-type :
BackupEnd 
| Connect 
| ConnectFailed 
| DatabaseStart
| DBDiskSpace
| Deadlock 
| "Disconnect" 
| GlobalAutoincrement 
| GrowDB
| GrowLog 
| GrowTemp
| LogDiskSpace 
| RAISERROR
| ServerIdle 
| TempDiskSpace

trigger-condition :
event_condition( condition-name ) { = | < | > | != | <= | >= } value

schedule-spec :
[ schedule-name ]
   { START TIME start-time | BETWEEN start-time AND end-time }
   [ EVERY period { HOURS | MINUTES | SECONDS } ]
   [ ON { ( day-of-week, ... ) | ( day-of-month, ... ) } ]
   [ START DATE start-date ]

event-name | schedule-name :  identifier

day-of-week :  string

value | period | day-of-month :  integer

start-time | end-time : time

start-date : date

ALTER EVENT event-name SET HIDDEN

此语句可用于更改通过 CREATE EVENT 创建的事件定义。可能的用法包括：

如果需要更改某个事件，可在该事件运行时通过执行 ALTER EVENT...DISABLE 语句将其禁用。要在 Sybase Central 中禁用某个事件，请右击该事件，然后清除 [已启用] 选项。禁用该事件并不会中断当前事件处理程序的执行；事件处理程序会继续执行，直到完成。事件处理程序完成后，它不会重新启动，直到您重新启用它。您可以更改定义，然后重新启用。要确定哪些事件正在运行，请执行以下语句：

SELECT * 
FROM dbo.sa_conn_info()
WHERE CONNECTION_PROPERTY( 'EventName',Number ) = 'event-name';

您必须具有 ALTER ANY OBJECT 或 MANAGE ANY EVENT 系统特权。

自动提交。

• SYSEVENT 系统视图
• BEGIN 语句
• CREATE EVENT 语句
• 系统事件
• 隐藏事件处理程序