MySQL Data Dictionary Query Toolbox

Databases and schemas

List databases (schemas) on MySQL server
List schemas in MySQL database
List user created databases (schemas) in MySQL

Tables

List tables in MySQL database
List tables from all databases in MySQL
List MyISAM tables in MySQL database
List InnoDB tables in MySQL database
Identify table storage engine in MySQL database (schema)
Find recently created tables in MySQL database
Find recently modified tables in MySQL database

Columns

List table columns in MySQL database
List all columns in specific table in MySQL database
List all table columns with details (PKs, UKs, FKs, Default, Computed, etc.) in MySQL database
List all computed (generated) columns in MySQL database

Views

List views in MySQL database
List views in MySQL with their scripts
List views columns in MySQL database
List tables used by a view in MySQL database

Primary keys

List all primary keys (PKs) in MySQL database
List all primary keys (PKs) and their columns in MySQL database
List tables with their primary keys (PKs) in MySQL database
Find tables without primary keys (PKs) in MySQL database
How many tables don't have primary keys (with percentage) in MySQL database

Foreign keys

List foreign keys in MySQL database
List foreign keys with columns in MySQL database
List table columns with their foreign keys in MySQL database
List all tables referenced by a specific table (by FK) in MySQL database
List all tables referencing a specific table (by FK) in MySQL database
List tables with the most foreign keys in MySQL database
List the most referenced tables (by FK) in MySQL database
List tables with most relationships in MySQL database
Find tables without foreign keys in MySQL database
Find tables that are not referenced by foreign keys in MySQL database
Find tables without relationships - Loner Tables - in MySQL database
Loner Ratio - How many tables do not have relationships in MySQL database

Unique keys

List unique keys and indexes in MySQL database

Default values

List all default values in MySQL database
List table default values in MySQL database
Summary of default values in MySQL database

Constraints

Find required (non nullable) columns in MySQL database
Check if is column nullable in MySQL database

Indexes

List all indexes in MySQL database
List table indexes in MySQL database
List unique indexes in MySQL database

Data types

Find most used data type in MySQL database
Find all numeric columns in MySQL database
Find all string (character) columns in MySQL database
Find all date and time columns in MySQL database
Find all enum columns in MySQL database
Find all spatial data columns in MySQL database
Find all JSON data columns in MySQL database
Find large object (LOB) data type columns in MySQL database
Find tables with large object (LOB) data type columns in MySQL database

Triggers

List triggers in MySQL database
List triggers by table name in MySQL database

Functions and stored procedures

List stored procedures and functions in MySQL database
List stored procedure parameters in MySQL database

Jobs/events

List events on MySQL server

Dependencies

Find where specific function is used in MySQL database

Searching database

Find databases containing a particular table in MySQL

Searching schema

Find a table by name in MySQL database
Find tables with names that contain a specific prefix in MySQL database
Find tables with names that contain a specific suffix in MySQL database
Find tables with a specific string in the name in MySQL database
Find tables with digits in their names in MySQL database
Find tables with a specific column name in MySQL database
Find table that DON'T have a column with specific name in MySQL database

Schema statistics

Find number of tables in MySQL database
Find number of columns in MySQL database
List tables with the largest number of columns in MySQL database
Average number of columns per table in MySQL database

Schema naming

Find most popular column names in MySQL database
Get column name length distribution in MySQL database
List columns by name length in MySQL database

Security and users

List users in MySQL database

Session

List sessions / active connections on MySQL server
Find last query executed by specific session on MySQL server
Terminate (kill) a specific session on MySQL server

Environment

How to check the MySQL version
How to check the MySQL edition
How to find operating system (OS) that MySQL database runs on

Number of rows

List tables by the number of rows in MySQL database
Find empty tables in a MySQL database
Number of tables by the number of rows in MySQL database

Data size

List tables by their size in MySQL database
List tables by the size of data and indexes in MySQL database
List idexes by their size in MySQL database
List tables by the size of their indexes in MySQL database
List 10 largest tables in MySQL database
Find database size allocated for LOB data in MySQL database

Schema compare

Compare tables and columns in two schemas in MariaDB database

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.

There are no comments. Click here to write the first comment.

Supported Technologies

Metadata Management: Why Start Now?

Why Dataedo?

Dataedo Cartoons

MySQL Data Dictionary Query Toolbox

Supported
Technologies