Information Schema Reference

Views in the information schema surface metadata about workspaces and all the components within them. SingleStore Helios supports the same information_schema views as MySQL, as well as a variety of additional views that are specific to SingleStore. The MySQL views are often useful, but it is important to note that some are included mostly for compatibility purposes, meaning that values for some columns may always be NULL.

Many of the information schema views have an mv_ version, which is a view that aggregates over lmv_ views that are generated independently on each leaf.