MariaDB Data Dictionary Query Toolbox

Databases and schemas

List databases (schemas) on MariaDB instance
List schemas in MariaDB database
List user created databases (schemas) in MariaDB

Tables

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

Columns

List all columns in specific table in MariaDB database
List all computed columns in MariaDB database

Views

List views in MariaDB database
List views in MariaDB database with their scripts
List views columns in MariaDB database

Primary keys

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

Foreign keys

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

Unique keys

List unique keys and indexes in MariaDB database

Check constraints

List all check constraints in MariaDB database
List table check constraints in MariaDB database

Default values

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

Constraints

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

Indexes

List all indexes in MariaDB database
List table indexes in MariaDB database
List unique indexes in MariaDB database

Data types

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

Triggers

List triggers in MariaDB database
List triggers by table name in MariaDB database

Functions and stored procedures

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

Jobs/events

List events on MariaDB server

Searching database

Find databases (schemas) containing a particular table on MariaDB server

Searching schema

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

Schema statistics

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

Schema naming

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

Security and users

List users in MariaDB database

Session

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

Environment

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

Number of rows

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

Data size

List tables by their size in MariaDB database
List idexes by their size in MariaDB database
List tables by the size of their indexes in MariaDB database
List 10 largest tables in MariaDB database
Find database size allocated for LOB data 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

MariaDB Data Dictionary Query Toolbox

Supported
Technologies