Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Function management
8. Summary


Congratulations! You've just completed function management. It's time to quickly review what we've learned in this part:

  • The CREATE FUNCTION statement is used to create a new function.
  • The 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.
  • The 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!


Click Next exercise to finish this part.