I need an help with the usage of WITH CHECK OPTION in Update and Delete . I need an example with explanation , as I need to provide an demo on the usage. Any help is really appreciated.
Below is the command I have tried for Insert but not sure about Update and Delete.
INSERT INTO (SELECT department_id, department_name, location_id
FROM departments WHERE location_id < 2000 WITH CHECK OPTION)
VALUES (9999, 'Entertainment', 2500);