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.
Further Reading
Explore Stored Procedure & SQL Scripting for a complete language reference, including variable handling, control flow, cursors, and dynamic SQL usage within procedures.