Hi everyone,
When basing a temporary table of a source table, are triggers included
by default? I have this statement;
CREATE TEMPORARY TABLE dev_main (
LIKE prod_main
INCLUDING ALL
EXCLUDING INDEXES
EXCLUDING CONSTRAINTS
) ON COMMIT DELETE ROWS;
And wondering if there is a trigger (row-based after) on prod_main
it'll fire also on dev_main? I can't find anything in the
documentation that suggests either way nor can I see an explicit
EXCLUDING option to be sure triggers aren't copied.
Does anyone know?
Cheers,
Jim
--
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London