6.3.1. mysql.utilities.command.grep — Search Databases for Objects

This module provides utilities to search for objects on a server.
The module defines a set of object types that
can be searched by searching the fields of
each object. The notion of an object field is very loosely defined
and means any names occurring as part of the object definition.
For example, the fields of a table include the table name, the
column names, and the partition names (if it is a partitioned
table).

Constants

The following constants denote the object types that can be
searched.

mysql.utilities.command.grep.ROUTINE

mysql.utilities.command.grep.EVENT

mysql.utilities.command.grep.TRIGGER

mysql.utilities.command.grep.TABLE

mysql.utilities.command.grep.DATABASE

mysql.utilities.command.grep.VIEW

mysql.utilities.command.grep.USER

The following constant is a sequence of all the object types that
are available. It can be used to generate a version-independent
list of object types that can be searched; for example, options
and help texts.