SQL to show all tables in database - character set / collation settings

Question

SQL to show all tables in database - character set / collation settings

What SQL should I run to show all tables in database with related settings like table engine, character set / collation ? How can I get these information ?

0

Report

27 May 2021 at 08:42 AM

Stor

sql

2 answers

OK

Tim · Answer 1

Hi,

To get the list of all tables in database by using SQL, you can use:

SHOW TABLE STATUS;
In the results, you can find information about table engine, character set etc.

Stor · Answer 2

Is it possible to somehow get the results using SELECT, so I can use the results also for other purposes ?

SQL to show all tables in database - character set / collation settings

sql

Error: Illegal parameter data types INT and row for operation '='

Is faster one big SQL query or multiple small SQL queries ?

Fix error: mysqli_select_db / query expects 2 arguments, 1 given

Copy and update rows in the same table with autoincrement - SQL

Fix SQL error Index for table 'user_db' is corrupted, try to repair it

MySQL error: Unknown table engine 'InnoDB' - how to fix ?

Insert or update current date in DATETIME format - SQL