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

时间:2024-12-06 15:12:41

示例

修改触发器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-910-dws/dws_06_0147.html