📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Get Started

Quick Start

Guides

Connect
Manage Resources
Data Integration
Load Data
Unload Data
Multimodal Data Analytics
Performance Tuning
Security & Reliability
Management

Troubleshooting

Tutorials

Ingest & Stream Data
Migrate Data

Reference

SQL Reference
General Reference

Support Services

Stored Procedure

This page provides a comprehensive overview of Stored Procedure operations in TiDB Cloud Lake, 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 TiDB Cloud Lake 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.

Stored Procedure

Procedure Management

Procedure Information

Further Reading

Was this page helpful?