This article shows you how to use ALTER TRIGGER and ALTER TABLE to enable and disable triggers.

Date: 2019-08-11 View: 1520

The ALTER FUNCTION statement explicitly recompile a standalone function. Sometimes, ALTER TABLE on the table being used in function will cause the function becomes INVALID, we need to recompile (alter function) it to make it VALID again.

Date: 2019-08-11 View: 1520