Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Where are stored procedures stored?

April 26, 2017procedures stored

0

Posted

Where are stored procedures stored?

4 Answers

0

Posted

In the proc table of the mysql system database. However, you should not access the tables in the system database directly. Instead, use SHOW CREATE FUNCTION to obtain information about stored functions, and SHOW CREATE PROCEDURE to obtain information about stored procedures. See Section 13.5.4.8, “SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax”, for more information about these statements. You can also query the ROUTINES table in the INFORMATION_SCHEMA database — see Section 22.14, “The INFORMATION_SCHEMA ROUTINES Table”, for information about this table.

0

Posted

In the proc table of the mysql system database. However, you should not access the tables in the system database directly. Instead, use SHOW CREATE FUNCTION to obtain information about stored functions, and SHOW CREATE PROCEDURE to obtain information about stored procedures. See Section 12.5.5.11, “SHOW CREATE PROCEDURE Syntax”, for more information about these statements. You can also query the ROUTINES table in the INFORMATION_SCHEMA database — see Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”, for information about this table.

0

Posted

In the proc table of the mysql system database. However, you should not access the tables in the system database directly. Instead, use SHOW CREATE FUNCTION to obtain information about stored functions, and SHOW CREATE PROCEDURE to obtain information about stored procedures. See Section 12.5.4.5, “SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax”, for more information about these statements. You can also query the ROUTINES table in the INFORMATION_SCHEMA database — see Section 22.14, “The INFORMATION_SCHEMA ROUTINES Table”, for information about this table.

0

Posted

In the proc table of the mysql system database. However, you should not access the tables in the system database directly. Instead, use SHOW CREATE FUNCTION to obtain information about stored functions, and SHOW CREATE PROCEDURE to obtain information about stored procedures. See Section 12.5.4.8, “SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax”, for more information about these statements. You can also query the ROUTINES table in the INFORMATION_SCHEMA database — see Section 23.14, “The INFORMATION_SCHEMA ROUTINES Table”, for information about this table.