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.