Skip to content
Dell Data Analytics Engine 462-e.10 LTS logo
SHOW CREATE FUNCTION
Type to start searching
    • SQL statement syntax

    Get started

    • What is Starburst Enterprise?
    • Learn Starburst Enterprise
    • Versions
    • Release notes
    • Get support

    For all users

    • Starburst Enterprise web UI
    • Clients
    • Data products
    • Insights

    Use SQL

    • SQL language
    • SQL statement syntax
      • Statement listing
        • Statements A-F
        • Statements G-R
        • Statements S-Z
          • SELECT
          • SET PATH
          • SET ROLE
          • SET SESSION
          • SET TIME ZONE
          • SHOW CATALOGS
          • SHOW COLUMNS
          • SHOW CREATE FUNCTION
            • Synopsis
            • Description
            • Examples
            • See also
          • SHOW CREATE MATERIALIZED VIEW
          • SHOW CREATE SCHEMA
          • SHOW CREATE TABLE
          • SHOW CREATE VIEW
          • SHOW FUNCTIONS
          • SHOW GRANTS
          • SHOW ROLE GRANTS
          • SHOW ROLES
          • SHOW SCHEMAS
          • SHOW SESSION
          • SET SESSION AUTHORIZATION
          • SHOW STATS
          • SHOW TABLES
          • START TRANSACTION
          • TRUNCATE
          • UPDATE
          • USE
          • VALUES
    • Functions and operators
    • SQL routines

    For data engineers

    • Define catalogs
    • Object storage
    • Materialized views
    • Query optimizer

    Connect to data sources

    • Connector overview
    • Object storage connectors
    • Non-object storage connectors
    • Utilities
    • Community-supported connectors
    • Starburst connectors feature matrix
    • Monitor and manage cost and performance

    For platform administrators

    • Administration topics
    • Performance, logging, and governance features
    • Security
    • Starburst Enterprise REST API

    SEP deployment mechanisms

    • Starburst Enterprise license
    • Deploy with Kubernetes
    • Manual installation and license

    Appendix

    • Trino developer guide
    • Version-specific notices and information
    • Topic areas
    • SHOW CREATE FUNCTION
      • Synopsis
      • Description
      • Examples
      • See also

    SHOW CREATE FUNCTION#

    Synopsis#

    SHOW CREATE FUNCTION function_name
    

    Description#

    Show the SQL statement that creates the specified function.

    Examples#

    Show the SQL that can be run to create the meaning_of_life function:

    SHOW CREATE FUNCTION example.default.meaning_of_life;
    

    See also#

    • CREATE FUNCTION

    • DROP FUNCTION

    • SHOW FUNCTIONS

    • Introduction to SQL routines

    • SQL environment properties

    Previous SHOW COLUMNS
    Next SHOW CREATE MATERIALIZED VIEW