DESC FUNCTION

The DESCRIBE FUNCTION command is used to view detailed information about a created function, including its name, parameters, return type, function body, and more.

Syntax

DESC[RIBE] FUNCTION [EXTENDED] [schema_name.]<function_name>;

Parameter Description

ParameterDescription
DESC / DESCRIBEBoth are equivalent and can be used interchangeably
EXTENDEDOptional. Retrieves extended information about the function, including comment, determinism, data access properties, owner, and creation time
function_nameThe name of the function. If the function resides in a specific schema, use the schema_name.function_name format

Usage Examples

Example 1: View basic function information

DESC FUNCTION my_schema.calculate_total;

Example 2: View extended function information

DESC FUNCTION EXTENDED my_schema.calculate_total;
DROP FUNCTION
SHOW FUNCTIONS
Singdata © 2024 Singdata, Inc. All Rights Reserved.