Skip to content

Instantly share code, notes, and snippets.

@mesmacosta
Created December 11, 2020 17:32
Show Gist options
  • Save mesmacosta/ee1812329ebfd9cf3a772fac97920921 to your computer and use it in GitHub Desktop.
Save mesmacosta/ee1812329ebfd9cf3a772fac97920921 to your computer and use it in GitHub Desktop.
SELECT f.SCHEMA_NAME AS SCHEMA_NAME,
f.FUNCTION_NAME AS function_name,
f.INPUT_PARAMETER_COUNT AS input_parameter_count,
f.RETURN_VALUE_COUNT AS return_value_count,
f.DEFINITION AS definition,
f.IS_VALID AS is_valid,
f.OWNER_NAME AS owner_name,
f.CREATE_TIME AS create_time
FROM SYS.FUNCTIONS f
// ... Omitted to improve readability
ORDER BY f.SCHEMA_NAME,
f.FUNCTION_NAME;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment