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 ;