Database object

Question

How to find a MySQL data base object ?

Dhaval Patel · Answer

but this stored procedure find all database objects under passed database name. and @arjun 's question is how to find objects

Prashant Chaudhary · Answer

Hey my frnd you can use.... CREATE [DEFINER = { user | CURRENT_USER }] PROCEDURE sp_name ([ proc_parameter [,...]]) [ characteristic ...] routine_body CREATE [DEFINER = { user | CURRENT_USER }] FUNCTION sp_name ([ func_parameter [,...]]) RETURNS type [ characteristic ...] routine_body proc_parameter : [ IN | OUT | INOUT ] param_name type func_parameter : param_name type type : Any valid MySQL data type characteristic : COMMENT ' string ' | LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER }

Dhaval Patel · Answer

Dear Arjun please find below link about database object Stored procedure to Find database objects http://kedar.nitty-witty.com/blog/stored-procedure-to-find-database-objects This post help you then mark as " Accepted Answer "

Database object

Answers (3)