martes, 29 de diciembre de 2015

MYSQL - Listar objetos de esquemas

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'

No hay comentarios:

Publicar un comentario