SELECT * FROM (
select TABLE_SCHEMA AS ESQUEMA, TABLE_TYPE AS TIPO, COUNT(1) AS CONTADOR from
INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA, TABLE_TYPE
UNION ALL
select ROUTINE_SCHEMA AS ESQUEMA, ROUTINE_TYPE AS TIPO, COUNT(1) AS CONTADOR from
INFORMATION_SCHEMA.ROUTINES GROUP BY ROUTINE_SCHEMA, ROUTINE_TYPE) det
WHERE det.ESQUEMA='sgesquemasys'
