Skip to content
Dell Data Analytics Engine 468-e.5 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

    For Dell Data Processing Engine users

    • Overview
    • Command line interface
    • Dell Data Processing Engine API
    • Release notes

    Use SQL

    • SQL language
    • SQL statement syntax
      • ALTER CATALOG
      • ALTER MATERIALIZED VIEW
      • ALTER SCHEMA
      • ALTER TABLE
      • ALTER VIEW
      • ANALYZE
      • CALL
      • COMMENT
      • COMMIT
      • CREATE CATALOG
      • 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 CATALOG
      • 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 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
      • SHOW STATS
      • SHOW TABLES
      • START TRANSACTION
      • TRUNCATE
      • UPDATE
      • USE
      • VALUES
    • Functions and operators
    • UDFs

    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
    • 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

    • User-defined functions

    • SQL environment properties

    Previous SHOW COLUMNS
    Next SHOW CREATE MATERIALIZED VIEW