Spring Deals - hours only!Up to 70% off on all courses and bundles.-Close
Function management
7. DROP FUNCTION IF EXISTS

Instruction

Great! Attempting to DROP a function that does not exist will cause an error, so it's highly recommended that you use the DROP command along with the IF EXISTS option.

DROP FUNCTION IF EXISTS circle_area(decimal);

After the DROP FUNCTION IF EXISTS command, you have to specify the name, as well as the types of arguments, of the function that you would like to remove.

Exercise

Drop the get_circle_area(integer) function, but only do so if it exists.