#
        #  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 ;