31.3. Limitations of INFORMATION_SCHEMAThe INFORMATION_SCHEMA implementation is fairly complete, but there are some kinds of information that it does not yet contain. For example, there are no tables for routine parameters or referential constraints for foreign keys. These omissions may be addressed in the future. INFORMATION_SCHEMA serves solely as a means of access for metadata. SHOW statements also serve this purpose, but the domain of SHOW extends into other areas as well. Certain SHOW statements provide information about the server's configuration or operational state. Some examples:
|