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
Insert or update current date in DATETIME format - SQL
Fix SQL error Index for table 'user_db' is corrupted, try to repair it
MySQL error: Unknown table engine 'InnoDB' - how to fix ?
SQL query with SELECT COUNT() in SELECT - subquery example
Trending questions
How to calculate inverse currency exchange rate ? Remove or hide bottom navigation bar with buttons on Android How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate how many Man Days are 3 Man Hours ? How to add side by side rows in excel pivot table ? Best free attractions in London - free things to do in London Difference between Standard and Vivid screen mode on Android
How to calculate inverse currency exchange rate ? Remove or hide bottom navigation bar with buttons on Android How to change QWERTZ keyboard to QWERTY in Windows 10 ? How to calculate how many Man Days are 3 Man Hours ? How to add side by side rows in excel pivot table ? Best free attractions in London - free things to do in London Difference between Standard and Vivid screen mode on Android
Follow us on Facebook
2022 AnswerTabsTermsContact us