Submitted by: lacak (lacak)

Votes: 1

extend DDL SQL to add possibilty enable/disable all triggers per table or per database

Possible solutions /discused in fb-devel/ :

1.) ALTER TRIGGER ANY [ON <table name>] {ACTIVE | INACTIVE}
-- combines functionality 2 and 3 with syntax compatible with
existing Firebird ALTER TRIGGER statement

2.) ALTER TABLE table_name [ENABLE|DISABLE] TRIGGER [trigger_name|ALL]
-- syntax compatible with PostgreSQL and Oracle, but only for one table

3.) ALTER DATABASE [ENABLE|DISABLE] TRIGGER [trigger_name|ALL]
-- One DDL can enable/disable all triggers on all tables