Maria DB: show tables;

MariaDB [(none)]> show tables;
ERROR 1046 (3D000): No database selected

MariaDB

• show tables
• show table status
• show table status like '%'; (Includes engine type)
• show table status where name = "YOUR_TABLE_NAME" (Includes engine type)

Size of MariaDB tables

SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Ref: https://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database

Related terms

• create table
• create database
• Databases: list tables
• List databases
• show engines;
• show plugins;

See also

• Table, foreign table, external table, show table, Delete rows of a table, Table Partitioning (PARTITION BY RANGE), \dt, Hash table, CREATE TABLE, DROP TABLE, ALTER TABLE, SHOW TABLES, TRUNCATE
• show table