Overview

System tables are managed by the DBMS (Database Management System), which provides visibility into how the databases work internally. In this article, I will go over the system tables and their use cases for SQL Server, Oracle, PostgreSQL, and MySQL databases.

MySQL Queries

1. See how large each table is in terms of rows to identify large data sets or usage hotspots.