Congratulations! You've just completed function management. It's time to quickly review what we've learned in this part:
CREATE FUNCTION statement is used to create a new function.
CREATE OR REPLACE FUNCTION command allows us to change the definition of a function. If the specified function doesn't exist, the command creates it. If the function exists, it is replaced.
- To rename a function, you can use the
ALTER FUNCTION ... RENAME TO command.
DROP command with the
IF EXISTS option can be used to remove a function that is no longer needed.
We hope you enjoyed this part and learned something new about function management. See you in the last part!