MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
This view summarizes the types of objects within each schema. By default, rows are sorted by schema and object type.
For MySQL instances with a large number of objects, this view might take a long time to execute.
The schema_object_overview view
has these columns:
db
The schema name.
object_type
The object type: BASE TABLE,
INDEX
(,
index_type)EVENT, FUNCTION,
PROCEDURE, TRIGGER,
VIEW.
count
The number of objects in the schema of the given type.