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 ?
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.
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.
Is it possible to somehow get the results using SELECT, so I can use the results also for other purposes ?
Related questions
Error: Illegal parameter data types INT and row for operation '='
Is faster one big SQL query or multiple small SQL queries ?
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
Insert or update current date in DATETIME format - SQL
MySQL error: Unknown table engine 'InnoDB' - how to fix ?
SQL query with SELECT COUNT() in SELECT - subquery example
Trending questions
Remove or hide bottom navigation bar with buttons on Android Man Month calculation - how many man days or man hours ? How to calculate inverse currency exchange rate ? How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate how many Man Days are 3 Man Hours ? Samsung Galaxy A & F better than M series ? What's the difference ?
Remove or hide bottom navigation bar with buttons on Android Man Month calculation - how many man days or man hours ? How to calculate inverse currency exchange rate ? How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate how many Man Days are 3 Man Hours ? Samsung Galaxy A & F better than M series ? What's the difference ?
Find us on Facebook
2023 AnswerTabsTermsContact us