Database object

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

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 }

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"