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. | |||||||||||
| |||||||||||
Is it possible to somehow get the results using SELECT, so I can use the results also for other purposes ? | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |