#
#  requirements: MySQL 5
#  stored procedure: show_all_index
#  parameter:database_name  database name
#
#  description:  show all indexes in database
#

DELIMITER \\

DROP PROCEDURE IF EXISTS `show_all_index`\\

CREATE PROCEDURE show_all_index(IN database_name VARCHAR(100))

BEGIN
  select * from information_schema.statistics where information_schema.statistics.table_schema = database_name;
END\\

DELIMITER ;