Skip to content
Starburst Galaxy SQL reference logo
Documentation: Starburst Galaxy SQL reference SHOW CREATE FUNCTION
Product:
  • Get started
  • Starburst Galaxy
  • Starburst Enterprise
  • Ecosystems
  • Resources
  • SQL statement syntax
  • SQL language
  • SQL statement syntax
    • ALTER MATERIALIZED VIEW
    • ALTER SCHEMA
    • ALTER TABLE
    • ALTER VIEW
    • ANALYZE
    • CALL
    • COMMENT
    • COMMIT
    • CREATE FUNCTION
    • CREATE MATERIALIZED VIEW
    • CREATE ROLE
    • CREATE SCHEMA
    • CREATE TABLE
    • CREATE TABLE AS
    • CREATE VIEW
    • DEALLOCATE PREPARE
    • DELETE
    • DENY
    • DESCRIBE
    • DESCRIBE INPUT
    • DESCRIBE OUTPUT
    • DROP FUNCTION
    • DROP MATERIALIZED VIEW
    • DROP ROLE
    • DROP SCHEMA
    • DROP TABLE
    • DROP VIEW
    • EXECUTE
    • EXECUTE IMMEDIATE
    • EXPLAIN
    • EXPLAIN ANALYZE
    • GRANT privilege
    • GRANT role
    • INSERT
    • MATCH_RECOGNIZE
    • MERGE
    • PREPARE
    • REFRESH MATERIALIZED VIEW
    • RESET SESSION
    • RESET SESSION AUTHORIZATION
    • REVOKE privilege
    • REVOKE role
    • ROLLBACK
    • SELECT
    • SET PATH
    • SET ROLE
    • SET SESSION
    • SET SESSION AUTHORIZATION
    • SET TIME ZONE
    • SHOW CATALOGS
    • SHOW COLUMNS
    • SHOW CREATE MATERIALIZED VIEW
    • SHOW CREATE FUNCTION
      • SHOW CREATE FUNCTION
        • Synopsis
        • Description
        • Examples
        • See also
    • SHOW CREATE SCHEMA
    • SHOW CREATE TABLE
    • SHOW CREATE VIEW
    • SHOW FUNCTIONS
    • SHOW GRANTS
    • SHOW ROLE GRANTS
    • SHOW ROLES
    • SHOW SCHEMAS
    • SHOW SESSION
    • SHOW STATS
    • SHOW TABLES
    • SQL entity kinds and privileges
    • START TRANSACTION
    • TRUNCATE
    • UPDATE
    • USE
    • VALUES
    • Row pattern recognition in window structures
  • Functions and operators
  • User-defined functions
  • SHOW CREATE FUNCTION
    • Synopsis
    • Description
    • Examples
    • See also

SHOW CREATE FUNCTION#

Synopsis#

SHOW CREATE FUNCTION function_name

Description#

Show the SQL statement that created the specified function.

Examples#

Show the SQL that can be run to create the meaning_of_life User-defined functions:

SHOW CREATE FUNCTION meaning_of_life;

or

SHOW CREATE FUNCTION galaxy.functions.meaning_of_life;

See also#

  • CREATE FUNCTION

  • DROP FUNCTION

  • SHOW FUNCTIONS

  • User-defined functions

Is the information on this page helpful?

Yes

No

Skip
Previous SHOW CREATE MATERIALIZED VIEW
Next SHOW CREATE SCHEMA

Resources

  • Starburst Enterprise reference documentation
  • Video library
  • Glossary
  • Free O'Reilly book - Trino: The Definitive Guide
  • Trino Community Broadcast
  • Starburst blog

Contact and more

  • Starburst
  • Join our weekly demos
  • Start a trial
  • Get support
  • Contact us
Starburst Galaxy SQL reference logo
  • Copyright © 2017-2025
    Starburst Data
  • Trademark information