# Base de datos y objetos R5.

**Objetos.**

| Objeto | Maxicomercio | Déminus |
| :--- | :---: | :---: |
| *Tablas* | 250 | 260 |
| *Vistas* | 172 | 184 |
| *Procedures* | 89 | 91 |
| *Functions* | 1 | 1 |
| *Trigger* | 2 | 4 |

Estas consultas pueden ayudarte a contar los objetos de la base de datos, únicamente cambia mibd por el nombre de tu base de datos:

*Contar Tablas:* 

*Mysql>* SELECT COUNT(*) tb FROM Information_Schema.Tables WHERE TABLE_TYPE = 'BASE TABLE' AND table_schema = 'mibd ';

*Contar Vistas:*

*Mysql>* SELECT COUNT(*) vw FROM Information_Schema.Tables WHERE TABLE_TYPE = 'VIEW' AND table_schema = 'mibd ';

*Contar Procedimientos:*

*Mysql>* SELECT COUNT(*) sp FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_SCHEMA = 'mibd ';

*Contar Funciones:*

*Mysql>* SELECT COUNT(*) fn FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'FUNCTION' AND ROUTINE_SCHEMA = 'mibd ';

*Contar Triggers:*

*Mysql>* SELECT COUNT(*) tr FROM information_schema.`TRIGGERS` WHERE TRIGGER_SCHEMA = 'mibd ';