Stored Procedure

This page provides a comprehensive overview of Stored Procedure operations in Databend, organized by functionality for easy reference.

Procedure Management

Command	Description
CREATE PROCEDURE	Creates a new stored procedure
DROP PROCEDURE	Removes a stored procedure
CALL	Executes a stored procedure

Procedure Information

Command	Description
DESCRIBE PROCEDURE	Shows details of a specific stored procedure
SHOW PROCEDURES	Lists all stored procedures in the current database

note

Stored procedures in Databend allow you to encapsulate a series of SQL statements into a reusable unit that can be executed as a single command, improving code organization and maintainability.