Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
Metadata about stored routines can be obtained as follows:
Query the ROUTINES table of the INFORMATION_SCHEMA
database. See Section 20.19, "The INFORMATION_SCHEMA ROUTINES Table".
Use the SHOW
CREATE PROCEDURE and SHOW
CREATE FUNCTION statements to see routine definitions. See Section
13.7.5.11, "SHOW CREATE PROCEDURE Syntax".
Use the SHOW
PROCEDURE STATUS and SHOW
FUNCTION STATUS statements to see routine characteristics. See Section
13.7.5.29, "SHOW PROCEDURE STATUS Syntax".