数据仓库服务 GAUSSDB(DWS)-ALTER TRIGGER:示例

时间:2023-11-10 17:34:11

示例

修改触发器delete_trigger:

1
ALTER TRIGGER delete_trigger ON test_trigger_src_tbl RENAME TO delete_trigger_renamed;

禁用触发器insert_trigger:

1
ALTER TABLE test_trigger_src_tbl DISABLE TRIGGER insert_trigger;  

禁用当前表test_trigger_src_tbl所有触发器:

1
ALTER TABLE test_trigger_src_tbl DISABLE TRIGGER ALL; 
support.huaweicloud.com/sqlreference-dws/dws_06_0147.html