View difference between Paste ID: QHMiq4M4 and 6q7PyYkU

 DELIMITER //
 CREATE PROCEDURE country_hos
 (IN requested_column_name CHAR(20), IN requested_referenced_table_name CHAR(20))
 BEGIN
   select distinct table_name
   from information_schema.columns
   where (
   	table_schema = 'usa'
   	and column_name = requested_column_name
   	and table_name not in (SELECT table_name FROM information_schema.key_column_usage WHERE referenced_table_name = requested_referenced_table_name AND table_schema = 'usa')
   	and table_name not in (select table_name from information_schema.tables where table_rows = 0 and table_schema = 'usa'))
 END //
 DELIMITER ;